Hi Sami, I originally did it that way, but I couldn't edit it in the form. Bernie ----- Original Message ----- From: "Sami Aaron" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, August 18, 2004 9:24 AM Subject: [RBG7-L] - RE: Syntax for setting a condition for the 3rd table in a 4 table form
> 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 > > > > > > > > > >
