I was hoping someone can shed some light on this as I cannot seem to work this out
Heres my dilema-

I have an access database that has an employee table with EmpID as the primary key. I also have an authentication table that holds username, passwords, access levels, with a forign key of EmpID.
I am able to insert records into the employee table just fine but I cannot
insert any records into the authentication table mainly because it is linked
to the employee table via EmpID.

How can I get around this problem?...
Thanks!!

i got around it by creating a table userLevels and adding a field authorisation to my employee table, on my add/change employee page a made a dynamic menu which labels the authorisation level and inserts the unique id of that level into the employee.authorisation field. Don't forget to switch the values into your authentication check from label to id.

With kind regards,

Dennis van Galen
Webmaster KPN Services
Financial and Information Services