My company has implemented a new database system, I converted our old MDB file to a new MySQL Server.
The Issue:
On the form where we track work orders and status information we have a subform for notes, there is a relationship between the main forms table and the notes table, I linked the work order numbers together. My problem is when I create more than one new note access is defaulting to the last used Work Order number, anyone have any ideas?