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