Dont forget the InventDim table. Take a look at the Salestable/PurchTable Form for Inspiration....
On 12/22/06, tarun jalhotra <[EMAIL PROTECTED]> wrote: > > Take both tables as datasources and change the property (Join Source)of > workorderlines Datasource to workordertable.it will show you the records > in lines depending upon record selected in workordertable. > > hope it helps. > > gokhaleanu <[EMAIL PROTECTED] <gokhaleanu%40yahoo.com>> wrote: > hello to all, > > i need to Create table and lines functionality similar to salestable > form using > Tables - "workordertable" and "workorderlines" > Form - "workordertableform" > > "workordertable" has index - workorderNo > "workorderlines" has index - workorderNo and LineNo > > I have set relation on "workorderlines" table - > workordertable.workorderNo == workorderlines.workorderNo > > to achieve functionality of "workordertableform" same as "salestable" > form, (for example selecting one record of salestable, shows > corrosponding records from salesline table) which properties/ methods > should I change? > > Anuradha > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > [Non-text portions of this message have been removed] > > > -- Arijit Basu [Non-text portions of this message have been removed]
