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

Have you tried Dynamic Selection List?