Hi all,
Question I’m hoping you can help me with.
We have two tables called “Documents” and “Documents2” that contains around 300 columns (150/table) with unique information related to a specific document number and revision level e.g. Document “Doc001”, revision “A”. The primary key for both tables is an auto number field.
We are trying to create a form button that when clicked will add a new row to both tables with the same autonumber primary key, document number and an updated revision level e.g. Doc001 Rev B.
We’re struggling however on how to achieve this. Any help would be greatly appreciated.
Thanks in advance,
Question I’m hoping you can help me with.
We have two tables called “Documents” and “Documents2” that contains around 300 columns (150/table) with unique information related to a specific document number and revision level e.g. Document “Doc001”, revision “A”. The primary key for both tables is an auto number field.
We are trying to create a form button that when clicked will add a new row to both tables with the same autonumber primary key, document number and an updated revision level e.g. Doc001 Rev B.
We’re struggling however on how to achieve this. Any help would be greatly appreciated.
Thanks in advance,