Master/Detail

optimadev · Post by **optimadev** » Tue Apr 09, 2024 12:44 am

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 ?

mobhar · Post by **mobhar** » Tue Apr 09, 2024 12:49 am

Did you mean for both fields you setup as Lookup Table?

arbei · Post by **arbei** » Tue Apr 09, 2024 10:15 am

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.

optimadev · Post by **optimadev** » Wed Apr 10, 2024 2:03 am

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

mobhar · Post by **mobhar** » Wed Apr 10, 2024 2:57 pm

Have you tried Dynamic Selection List?