Hi

To give a bit of background this is an asset register for all assets and pat testing database in one. Two tables concerned are asset register and risk assessments. The reason the tables are separate is because not all items will need a risk assessment.

I have a form for adding items to the register which has multiple tabs the first one fill out the asset register table and has a primary key of asset id which is auto...