Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Linked Record Cells with Thousands of Records

Solved
Jump to Solution
249 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I have Table 1 with thousands of records. In Table 2, I want to summarize the data by linking the records and then using lookup fields to get specific info from each record all in a single cell. I’ve linked Table 1 to a field in Table 2, but to get all the records, I’d need to manually select each of the thousands of records to add them to the linked cell. Is there an easier way to do this?

I made a dummy database and screen recording to illustrate what I’m trying to do, but instead of 4 records per “company,” imagine thousands.

Thanks for any help.

1 Solution

Accepted Solutions

Based on your video it looks like the primary field of [Table 1] is the {Company Name} and the primary field of [Table 2] is also, for some reason, {Company Name}.

That means if you go to [Table 1] and copy the entire column for {Company Name} you can paste it into the field that links [Table 1] to [Table 2].

You may want to consider why {Company Name} is the primary field in [Table 1] instead of something that more uniquely identifies what each record is.

See Solution in Thread

1 Reply 1

Based on your video it looks like the primary field of [Table 1] is the {Company Name} and the primary field of [Table 2] is also, for some reason, {Company Name}.

That means if you go to [Table 1] and copy the entire column for {Company Name} you can paste it into the field that links [Table 1] to [Table 2].

You may want to consider why {Company Name} is the primary field in [Table 1] instead of something that more uniquely identifies what each record is.