I have a table that may have multiple lines from an order that are identical. I want to create a form with a where clause that will allow editing, but only  one of each line that is unique.

IE:
Table holds:

180500  Red
180500  Red
180500  Red
180500  Blue
180500  Blue
180500  Blue

My form using the where clause would only show:

18500  Red
18500  Blue

Dick Fey
Carpet Broker Inc

P: 913-894-9211
F: 913-894-0138


--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to