I have a table (Violations) that I am loading from a csv file. One of the columns is a key to another table (Violation Types).
There are only 3 different Violation Types in that table.
My CSV file includes which Violation Type a given Violation (row) should be. The SQL Data Generator wont let me switch that column away from Foreign Key Generator.
Is there anyway to have a bit more control in those Foreign Keys? Any way to load a number (1-3) to load give a value for the Foreign key.
I was hoping to avoid having to write a script to run afterwards to set those values.