how to link input of 3 tables
I am very new to this... making a database for a student paint conservator to archive hundreds of old paint recipes.
We have 3 tables; 'metadata', 'receipt info' and 'actual receipt'. All containing various fields of input. In the table metadata we made a unique key.
First we want this key to appear in the other tables.
Second we want to attach all data of the 3 tables to this key.
Can anyone help with these challenges.