I am not sure if I am going about this the right way, so I’d appreciate some ideas.
Goal: I have two tables. A “detail table” and a “main table”. The “main table” has a related list “link to another record” field to the “detailed table”.
In interface designer, I am hoping to create a search that lets me find records from the “main table” and by selecting an item it lets ‘grabs’ the related list of items from the detail table.
So, if I select three records from the main table, that each have 3 records in the detail table, it would show me the total of items from the detail table = 9.
Appreciate any thoughts! Thank you!