Results 1 to 1 of 1
  1. #1
    Join Date
    Mar 2014

    Unanswered: Best Way to Design Navigation Form?

    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?

    Thank you for your time,
    Attached Thumbnails Attached Thumbnails REPO-Relationships.jpg  

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts