Bernie - You could create a one-table view based on the third table that includes your WHERE clause. Then on your form include the view rather than the table. A one-table view should be editable.
Sami ------------------------------------------ Sami Aaron Software Management Specialists 19312 W 63rd Terr Shawnee KS 66218 913-915-1971 mailto:[EMAIL PROTECTED] www.softwaremgmt.com > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bernard Lis > Sent: Tuesday, August 17, 2004 10:48 PM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Syntax for setting a condition for the 3rd table in > a 4 table form > > > Here is my edit command: > > edit using customer arrange invhist by billdate=d, arrange OrdHdr by > orderdt=d where custno=.cno > > I want to select only those rows from OrdHdr where status in ('S','E','C') > What would be the correct syntax to accomplish this? > > Bernie Lis > > > >
