I need to generate data for a table and the situation exists where two fields are dependent on each other. For example, say I have two fields:
and I have a reference table with all of the data. I can generate data for each column independently using the SQL option, but I really need to make them dependent on each other. Like if the generator selects productID 4, the ProductDescription needs to be the correct description...
Any way to do this?