Hello.
I am fairly new to Microsoft access however I have a lot of experience with Excel.
I put together two tables.
1.Export_no_vat_TBL
2. Main_TBL
I'm trying to build a method that if I put information to the "Export_no_vat_TBL" it will automatically input the related information to the Main_TBL
However I'm not sure how to set this up.
I am also trying to change the ID type on the Export_no_vat_TBL.
However I am receiving the following message:
" First delete its relationships in the relationships window'
I'm not sure why I am receiving this message as I deleted all relationships between the two tables.
What am I doing wrong?
You can find my database at the following link:
https://drive.google.com/file/d/1H0z...ew?usp=sharing
Thank you in advance for your help.