Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    9

    Unanswered: Help creating a tabbed form to step through 4 related tables

    Hello all,

    Hopefully someone can help me with a tabbed form.

    Here is what I have……four tables (customer, site, job, and job items) a customer has many sites, a site has many jobs, and a job has many job items. All tables are in a one-to-many relationship.

    Here is what I want to happen…..build a tabbed form were tab one you can select or enter customer data, then click on tab two and enter/update site information for the related customer, then on tab three enter/update job information for that site, and finally on tab four I want to enter/update the job items related to the job. Basically, what I’m trying to do is use the tabbed form to step through four related tables.

    Any suggestions on how I might go about doing this. I tried creating a query with the four tables and using that on the tabbed form but it only allows me to view data not enter it.

  2. #2
    Join Date
    Jul 2004
    Location
    Southampton, UK
    Posts
    368
    Tabs are just a way of showing lots of fields on the same form (think paging down). This is not the right approach for what you want to do.

    I would approach this using three form/subforms:

    Customer/Site
    Site/job
    Job/Job items

    If you get them working independantly you can then think about a bit of code to go for one form/subform to the next e.g. selecting one of the sites on the Customer/Site form opens the Site/job form for that site.

    hth
    Chris

  3. #3
    Join Date
    May 2006
    Location
    Stoke on Trent, UK
    Posts
    4
    Sort of agree with Chris but, in more detail, to get it working you will need a sub-form on each tab. Each sub-form will be backed by a query which looks at the previous tab to see what the user selected.

    Consequently when a user changes a value on one tab (e.g. customer on the first tab) you will need to trigger an event to re-query the sub-form on the next tab.

    Hope this makes sense....

    Brian

Posting Permissions

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