Page 1 of 1
Master/Detail
Posted: Tue Apr 09, 2024 12:44 am
by optimadev
HI,
i have 2 table, Order and sales_items
in order table i have customerPO and in sales_items i have field customerPO
i make this table as master/detail table.
when i add master/detail page.
i want to dynamically show on detailed table the item that is belong to the customerPO that i select on master table.
how do i do this ?
Re: Master/Detail
Posted: Tue Apr 09, 2024 12:49 am
by mobhar
Did you mean for both fields you setup as Lookup Table?
Re: Master/Detail
Posted: Tue Apr 09, 2024 10:15 am
by arbei
You better use Master/Detail-Add page or Grid-Add page of the detail table (so you don't need to enter the foreign key), see the Master/Detail tutorial.
Re: Master/Detail
Posted: Wed Apr 10, 2024 2:03 am
by optimadev
what i am trying to achieve is to get the value of CustomerPO that been selected on master table on maste/detail add page
the use this value to become filter of dropdownlist on detail table.
so the dropdown list of detail table will be depending on value that been selected on master table
hope this clarify things
thanks
Re: Master/Detail
Posted: Wed Apr 10, 2024 2:57 pm
by mobhar