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]> 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]
