Re: Trouble getting a where command to work

Tech-Archive recommends: Fix windows errors by optimizing your registry

Ok Ill give it a go, thanks very much for your help Joan!!!


Joan Wild wrote:
Well that is your problem; the table design. There is no need to store all
the customer information in the Jobs table. You only need the CustomerID in
the Jobs table. Store information in only one place. In the relationship
window, you would create a relationship between the Customers Table and the
Jobs table - linked on CustomerID.

If you use the Forms Wizard, you can create a main form (based on the
Customer table) with a subform (based on the Jobs table). The wizard also
gives you the option of making the Jobs form a separate form rather than a
subform.

Detailed steps:
Create new Form using Form Wizard
Choose the Customer table; add the fields you want
Choose the Jobs table; add the fields you want
Click Next, and because you've defined a relationship between the two
tables, Access will give you the option of 'subform' or 'linked form'

In case I missed something the second table "jobs" also includes ALL the
fields off the "customers" one inc Name and customer ID.
[quoted text clipped - 32 lines]

DoCmd.OpenForm "NameofSecondForm", , , "CustomerID = " & Me.CustomerID

--
Message posted via http://www.accessmonster.com

.

Relevant Pages

  • Re: Sorting subforms
    ... machines and jobs. ... I have a main form contaning customer contact details. ... subform where I enter details of jobs carried ...
    (microsoft.public.access.forms)
  • Re: Part Numbering Systems for CAD management.
    ... Currently we have about 60 different customer folders ... seperate assemblies from parts. ... machining and fabricating prototypes. ... if you're doing 250 jobs per year and you can't pay off your 2 ...
    (comp.cad.solidworks)
  • Re: Need help export data
    ... Jeanette Cunningham -- Melbourne Victoria Australia ... database, will my frontend connect seamlessly to their .be database such ... Adding extra customer service reps to the table for customer service reps ... to the jobs table in the copy I made of the database. ...
    (microsoft.public.access.externaldata)
  • Re: Sorting subforms
    ... machines and jobs. ... I have a main form contaning customer contact details. ... subform where I enter details of jobs carried ...
    (microsoft.public.access.forms)
  • Re: Need help export data
    ... If I re-create the new fields on their backend .be ... database, will my frontend connect seamlessly to their .be database such that ... Adding extra customer service reps to the table for customer service reps is ... to the jobs table in the copy I made of the database. ...
    (microsoft.public.access.externaldata)