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.