I would like to pick your brain on how to setup two datasets.
I have one table MASTER with a unique identifier and more columns.
Then I have another table SALES with the same identifier, and more characteristics.
IDENTIFIER, not unique this time
I’d like to link records in MASTER to records in SALES, displaying them together, maybe on the same line?
It is a relation one-to-many. The unique identifier can link to many records in sales (generally two or three max).
Should I add a field list of sales to datatype MASTER? Or should I keep them separate and match them in a repeating group and match the unique identifier?
Thanks in advance for your help!