I have a question similar to some others I've seen on the forums.
I'm trying to load a table with data (call it table E) that must have a matching record in a different table (P). Unfortunately, the unique identifier in P is a composite key between 2 columns (for example, ID & Company).
At first I thought I'd do a simple lookup using the SQL statement generator - select statement, just make sure I was grabbing 2 valid answers for each column, generate data, and then address the errors with my other db tool. Unfortunately, after generating 100k records I only ended up with 7 that match... that's too many errors for my other tool.
How can I pull a composite key out of table P and use it to populate table E so that my generated data in E will match a real record in P?