| master detail form [message #79140] |
Thu, 02 May 2002 22:24  |
ranjan kumar dash
Messages: 15
Registered: February 2002
|
Junior Member |
|
|
i have 2 tables one is store master which has item_code,description,baance qty,unitname,amount,last_reciept_date,last_issue_date.
item_code is primary key
and other table is trans.which has
item_code,cost center,issue date,type,quantity,amount.
cost center column is refering from other table.here item_code is foreign key of store master.
My question is how i make a master detail form using this.which columns i should take to make it most user friendly.
|
|
|
|
| Re: master detail form [message #79152 is a reply to message #79140] |
Mon, 06 May 2002 13:06  |
Tyler
Messages: 123
Registered: January 2002
|
Senior Member |
|
|
When using forms, the forms will make the master detail for you. ie. make the Master block first, I believe that yours is STORE and after make the child block, trans. In the wizard you can make a join based of the id foreign key, this will make a master-detail relationship.
I hope that's what you were asking...Later>>
T
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
