WHERE … AND LIMIT = 1 I think that will bring up only the first occurrence. The alternate would be
WHERE … AND COUNT = LAST Albert > On Mar 1, 2018, at 11:37 AM, Carpet Broker, Dick Fey <[email protected]> > wrote: > > 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. -- 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.
