I have a temp table (in MS Access) with 7 columns. ID, projName, projInfo, enggFname, enggLname,devFname, devLname.
Using an " insert into select" statement, I insert a row with ID, projName and projInfo from tblProjects into tblTemp.
tblProjects also contains enggID and devID as foreign keys. Using these foreign keys and other filter criteria, I need to add the enggFName, enggLname to the already existing row in tblTemp. Then I have to repeat the process to add devFname and devLname to the row in tblTemp to complete the insert.
Can I do this in a single query? I have tried using union and append without success. I need to have only a single row with the data inserted in parts in the temp table.
Any suggestions as to how I can build the query, or write multiple queries but execute them after a single event?
Thanks in advance.