Form with 2 tables (1 Viewer)

[fernando.rosales]

Hi everyone Iam having a problem starting my database... I am trying to do some data entry using 2 tables in a form. Here is what I have:

tableUser
tableAudits
formUser
formAudits (set as datasheet view)

My main form is formUser and I have added a subform linked to formAudits using ID field as key. My issue here is that my subform (formAudits) can add multiple data such as you can see in the attachment. ( I tried no duplicates but It can still add even tho it does not save)

how can I make that go away or is there an easier way to do data entry with no duplicates using 2 tables in 1 form? I just want to be able to purely data entry.

 

[KenHigg]

You want it so that the user can not be their own auditor?

 

[fernando.rosales]

Never mind guys I got it to work.

Maybe I didnt explain it well enough but I figured it out. I changed my form audit to single form and works as I need it.

Thanks

I have attached a screen shot of the progress I have made since I got it wotking.

 

[KenHigg]

Glad you have it working -