Home » Developer & Programmer » Forms » master detail form
master detail form [message #79140] Thu, 02 May 2002 22:24 Go to next message
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 Go to previous message
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
Previous Topic: Not updating last Record
Next Topic: Difference between Oracle 9i Forms Developer and Oracle Forms Developer 6i
Goto Forum:
  


Current Time: Fri Mar 29 09:09:08 CDT 2024