ok, here's a new one on me but I'm sure it is common amongst the expertise here. i have an unbound entry form for requested work which then gets approved by a supervisor and moved to another table for a employee to do the work. along the employees path they have to fill out some description about the work they will do and the hours involved. this goes into a separate table related to the work table because most jobs will have several people working on it. so far fairly easy. today I'm informed that entry work with certain higher criteria must skip the approval process and go directly into the work table. again so far fairly easy. now my problem is that they want the requested work to also have default information to go into the secondary table associated with the work table. my head scratcher is that since this is an unbound entry form, i can write an insert SQL for the requested work to go directly into the work table but how do i write the second insert SQL to add the default information into the secondary table when i don't know what the primary ID is on the first entry to make it the foreign key of the secondary table. not sure i'm on the right mental path but my thought is
1. insert into work table
2. search for the highest primary key
3 insert into secondary table with the found primary key as foreign key.
not sure if this is making sence, please let me know if i need clarification and how you would handle this. thanks