I have setup a database - picture attached. I want to use a master navigation form with tabs to section out parts of the huge REPOs table for data entry. Each tab will be a subform that will use some combination of the five tables pictured.
My question is, Do I need to create a query with the primary keys from all tables as the record source for the navigation form and then create the subforms off of that? OR should I create individual forms for each tab querying only the tables needed for that tab and pass the primary key from tab to tab using VBA?
Which design would produce the best performance overall? Is there a better design for this scenario that I am missing?