I have a State table and County table, where the County table has a state_id with a foreign key back to the State table. I loaded the State data from a CSV file fine. I made a County.CSV file with the county name and state number and want to use that to load the County table, but the foreign key on state_id is locked so the counties get loaded to random states. I tried setting the table data source to the CSV, and just using CSV for the column sources, but nothing will let me change the Foreign Key Generator on state_id.
I read an old post that had this same issue and a response that it would be changed in 1.1. Is there any way to oerride the generator on a column with a Foreign Key?