Sep 19, 2023 11:12 AM
Hello,
I cannot figure out why I have a field which has multiple records linked to it even though I have not selected 'Allow linking to multiple records'.
My tables are 'Materials' and 'Inventory by Location'. The top photo is 'Inventory by Location' table showing the linked field to the Materials. Preferably, if materials are linked to a storage location a new record would be created instead of linking multiple materials to one inventory record because I have not selected 'Allow linking to multiple records', or if I need to make an automation for that to happen then airtable would block linking of multiple records instead of what has happened in the photo. Also, I would like to know why, in the bottom photo, there are repeated links to the same storage locations. Thanks for any advice/clarification!
Solved! Go to Solution.
Sep 19, 2023 12:40 PM
That is because they were linked from the OTHER table.
Even though Airtable gives you that toggle option there, it doesn't actually enforce it outside of that one particular field -- and only when entered through Airtable (i.e. not via external tools or via the API).
Sep 19, 2023 12:40 PM
That is because they were linked from the OTHER table.
Even though Airtable gives you that toggle option there, it doesn't actually enforce it outside of that one particular field -- and only when entered through Airtable (i.e. not via external tools or via the API).
Sep 19, 2023 12:51 PM
Thanks @ScottWorld