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?

Thanks,
Tyler