Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Updating ID from one table to another

134 0
Showing results for 
Search instead for 
Did you mean: 


I have two tables from a csv file. Programs and Partners. I have an Program_ID field in the programs table that is not an autonumber field and that links to a field in the partners table also called Program_ID. I then created a new autonumber field in the programs table so I can add new records later. But now I need to update the foreign key in the partners table with the new program id autonumber field in the program table. I tried this with automation but i keep getting test failed and I know I am doing something wrong. I don’t want a linked field because I just want to get rid of the old program ID fields when the new autonumber id is updated in the partners table.
Any help would be appreciated.

0 Replies 0