Hello! I am trying to link records with the same ID and I can’t figure out how to do it in buik - only one by one which is impractical for my purposes.
Essentially, I have a table (“Forms”) that contains student usernames and the forms they submitted, and I’m using the username as the record ID, so multiple, identical record IDs exist for all the different forms a particular student submitted (i.e. Username1 - Form A, and Username 1 - Form B are listed in different rows). The ideal result I am picturing is that, in my main table, I could use a ‘link to another record’ field that links to the Forms table, I would paste the usernames in this field, and then I’d have a lookup field which would display all the forms that correspond to that username (i.e. for Username1’s linked record, the lookup field would display “Form A, Form B”). However, when I set this up, it’s only displaying the first form that exists in the Forms table, and it only works the way I want it to if I one by one add records to the link field and select the same username however many times it exists in the Forms table.
I hope this made sense. I appreciate any possible solutions.