Hi,
So, I am Setting up a database for a number of Projects.
*Table 1 (Primary table): Projectname_Projectfocus_approval date_approved by.
The subsequent tables are for other Informations like Benefits, Investments, Return on Investment into the Projects, which also have columns for Project_name for example.
Now, I want to link all the tables to the Primary table (table 1), so that when project Name is changed in Table 1 (Primary), it affects all the other tables.
and also create a Combo Box in the forms that follows the same logic.
Thanks in advance