So I have a repeating table that I would like to be auto populated with the results of a query from a secondary data source that will have multiple results (AKA a repeating section I believe).
Is there a way to do this?
The reason I want to use the the repeating table is I want the user to be able to query the data from the secondary data source and then add/remove a row if necessary, fill in the new fields and then have a sum of all the costs with the new row added.
But I want the information pre filled for the user as much as possible from the query before they add or remove anything.
Is there another way I can accomplish without using code?
Hopefully I explained that properly,
Thanks,
Thomas