Just wondering if there is a way to insert into a table and the last 2 columns of the table are foreign keys to a lookup table.
at the moment i’m doing this…
-select from lookup table
-loop through insert document array
-loop through the select lookup table
-if a certain value from the insert document array[i] = lookup table array[i] value then populate values from the lookup table to the insert document array
after all of that then the insert document now has the last two column values populated to insert.
Just wondering is there a more effecient way? I dont want to loop connect to the db too many times.