Multi select Interface

Hi all,

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!

I don’t think Interfaces can do this yet.