Master-Detail concept

Hi,
I have Header table and detail table. I setup the M/D relationship and found that I need not to use FillWithDASql for detail table. It means DA will retrieve the record in detail table automatically. Am I right?

Hi,

Yes, it is as designed by default.


this scenario also can work:

  • retrieve 2 tables with FillWithDASql
  • apply m/d relation

Hi,
User searches a lot of header records from criteria. If using this design, should performance poorer than filtered detail records and then apply m/d relation?

Hi,

it depends on many factors: network stability, how many records in detail table, how busy is server, etc.

You should test both ways and choice better solution by yourself.

Hi,
I tried to FillWithDASql to Header table and details table. It will duplicate the data in details table when apply m/d relation.

Hi,

Can you create a simple testcase that reproduces this, pls?
I’ll check what is wrong