Retrieve related record to form with master detail relationship
452722Sep 8 2005 — edited Sep 10 2005Greetings Form Gurus!!!
Can someone give me an idea/code on how to retrieve related records to Form9i.The form is composed of 3 datablocks(Master-Detail) & 1 control block(1 button),tables to be used are show below.The field RelatedSalesOrderNo in the form is use to input the Related Sales OrderNo .After entering the value of Related Sales OrderNo, I click the button then it will display all the records that matches in Main_Order Table,Main_Order_Lines Table & Main_Order_Lines_Color Table.
Thanks in Advance ......
Best Regards,
Ben
-------------------------------------------------------------------------------------
Main_Order Table(Master)
RelatedSalesOrderNo
SalesOrderId(Primary Key)
SalesOrderNo(Unique)
----------------------------------------------
Main_Order_Lines Table(Detail/Master)
ModelID(Primary Key)
SalesOrderId(Foreign Key)
ModelCode(Unique)
--------------------------------------
Main_Order_Lines_Color Table(Detail)
ColorId(Primary Key)
ModelId(Foreign Key)
ModelColorCode(Unique)
-------------------------------------------