>Thanks for your help Erik,
>
>I am running the exe from each machine. I have the tables stored on the server. When I open the form to add in new assignments on both machines, its fine. But when I try to save records on both machines one saves and one says cannot update table, unique index violation. The index is autoincremented when clicking add. How do I solve this error?
>

It looks like your AutoIncrement scheme is suspect. How are you giving the records new ids?