Trying to generate values for a data table which has a column which is a foreign key to a status table.
Now the status table is already pre-populated but for some reason the data generation for the data table won't refer to this table but insists that we also generate data for this status table within the tool.
Do you know how I can tell the tool to read from the database rather than insisting on creating this data itself.
Data Generator - Foreign Keys
Re: Data Generator - Foreign Keys
It is necessary for such columns under Foreign Key to use not a Foreign Key generator, but a Table Or View generator.
In this case, the generator will take values for the table's children from the existing dataset in the parent one.
In this case, the generator will take values for the table's children from the existing dataset in the parent one.
Re: Data Generator - Foreign Keys
Many thanks for this response. Yes, I have converted my generator to use Tables and not Foreign Keys in these instances and it works a treat now.