why dont yuo just do it this way
soldier(SoldierID, SSN, LastName, FirstName.....)
soldier_phone(SoldierID, PhoneID, Number, Type (cell or home))
maybe you did complicate it a bit :)
yes this is what i did i already solved the problem, i created a function that would edit the table (actually i just issue a .edit then .update simultaneously) if an error occured the function will send a flag. the table is not that big anyway (max 20 records).
thanks pat
im running access97 on an NT environment using DAO my question is this - is there a way to check in code whether a record is currently edited by another user.
my problem is this i have table A with 2 fields bank# and date. users always edit the date field in table A. now in other modules there...