I'm trying to create a web interface for an access database that resides on one of my company's servers. Due to restrictions i can't use any other DB solution (shame as it would make it easier)
The database consists of 3 main tables, shown in the screen grab. My question is this, how do I perform an update to all 3 tables when I don't know the aboutYouID pk from the first table as this is being created in the table at the same time as the others?
Potentially more than one person could be updating their details at the same time so simply pulling the last record from the table and using this is impossible surely?