I am new to Access and I am using Access 2013.
I want to get the associated tables that are associated with a subform/table to update automatically with new data when it is inputted into the relevant field in the subform/table.
What I mean is, the relevant tables are called Production Companies, Casting Directors, Directors and the main table Submitted (which is the subform/table). The Submitted Table has the following fields Month/Yr Submitted, Role, Production, Pay, Production Company, Casting Director, Director, Notes, Production Date, Shoot Date and Location and I want to be able to input new production companies, Casting Directors and Directors using the subform/table so that they will update the separate tables each time there is a new entry is done (the fields are set to no duplicates) and they are combi boxes.
Any help will be appreciated.
I want to get the associated tables that are associated with a subform/table to update automatically with new data when it is inputted into the relevant field in the subform/table.
What I mean is, the relevant tables are called Production Companies, Casting Directors, Directors and the main table Submitted (which is the subform/table). The Submitted Table has the following fields Month/Yr Submitted, Role, Production, Pay, Production Company, Casting Director, Director, Notes, Production Date, Shoot Date and Location and I want to be able to input new production companies, Casting Directors and Directors using the subform/table so that they will update the separate tables each time there is a new entry is done (the fields are set to no duplicates) and they are combi boxes.
Any help will be appreciated.