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 <d...@carpetbroker.com> > 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 rbase-l+unsubscr...@googlegroups.com. > 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.