Dear sir or madam,



Please help me with my problem in programming-coding



I have setup One Main Table with at Primary Key "QID#"

which has three separate tables with the same primary

key. Each one of the tables have three different

people entering information into them; 



1) Each person when entering information need new

'QID#'

2) When a person deletes a record, none of the other

numbers need to change.





How do I do this function, from the main table.



Thank you for you time



Kenneth