I am new to using Airtable and need help.
I would like to have a user choose their name from a list in a table called (Inv by Rep) and then have a form or table populated with all of their records from another table called (Main Inv by Rep). When those records are returned, I want the Rep to be able to update the “Status” field and add a picture in the “Picture of Serial Number” field for just their records.
I tried to link the tables by Assigned Rep, but in form view, I can just pick the name from the list, it doesn’t return any records. Is it even possible to do what I am trying to do in Airtable?
Any help would be appreciated.