First off I am very new to Access and just starting to learn how powerful and useful it is for my scope.
I am trying to put a construction project database together which will include Projects, Venues, Subcontractors, and Trade/Specialties. When creating a new project I would like to choose from the list of Venues to use but if not already created in the venues table, I would be prompted to create it first. Also to be able to select multiple trades that would be applicable to that project. Subcontractors would also be able to choose what trades and specialties they can do and have that information tied to the project so when I create a report in the future, I can just select the trades I want and then the subcontractors would be shown with their company information.
Any help would be much appreciated. I am not looking for an exact coding or step by step but any tutorials or sites you might think would be relevant to helping me learn the procedures would be ideal.
Thank you