Automation to automatically populate linked records

[mdiesen]

Hello,

Im am trying to find a way to automatically populate a list of linked records in a field. Without it I would have to manually add them one at a time which takes forever. I added photos below for reference

[Alexey_Gusev]

Hi,
it should be easy, but I don't get your design. Why do you use such unusual self-linking in 'Link Location'?
About links to Revenue Ledger - I guess amount of records there must be near twice of Location table records and they should be linked here. How do you know which records to choose, and what fields do you have in Revenue Ledger table?

[mdiesen]

So to explain the structure, which is probably inefficient. 

My company offloads data for cellular carriers, we partner with companies that have properties where we can install cellular radios. These companies get a revenue share based on how much data each radio is passing. We Payout for each location but the location can have multiple radios. So I have the following tables in order of ownership 

Users -> Clients (company) -> Locations -> Access Points (Wireless radios) -> Revenue Ledger.

The "Revenue Ledger" is a CSV I have to manually import, which shows how much data each radio has passed each week. I have linked the "Access Points" to the revenue ledger but what im struggling with is how to have another sheet that shows how much all the radios have earned each week at the location they are at. Thats what this "Location Revenue" sheet is for.

[Alexey_Gusev]

Got it, you have link to Location table. I suppose it has some linking to AP table and you can add lookup representing a list of APs in each location? the same that you are trying to achieve in link field, but, in a format of simple text, not links.