If I have one main table with one primary key - QID#. Three other tables

from it which have the same primary key. The main table assigns the

QID# but information is entered by three different individuals in the

three tables.



1) How do you get the next available number from the main table 'QID'?



2) When the individuals are deleting information, how do you make the main

table recognize the fact that the number is left blank not changing the

rest of the number in the two other tables or the main table?



Thank you in advance,



Kenneth