Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2006
    Posts
    4

    Unanswered: Using two tables or related tables on one form

    Hi everyone, hope you can help?

    I have designed a repairs management database for our company, which is used to generate paper work for dispatching repairs to manufactures, the databes records phone type, date sent etc.

    I want to have a section where you can select which loan phone number has been issued (all our loan handsets are identified by number) and then have the make,model,IMEI populate automatically once the number is selected.

    I have created another table alongside the main table that contains this information but can't figure out how to assign these fields, do i need a certian type of relationship, do i need to have two tables on one form?

    I'm sure there is a way and it is right in front of my eyes but i just can't see it, can anyone please help.

    Many thanks

    Lestat

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    So your main table looks something like this..?
    Phones(PhoneID, make, model, IMEI, ...)

    Now, there are two solutions that I can see here, but first you have to ask yourself:
    Can one phone have more than one number at any one time?
    Do you want to save the phone number history?
    George
    Home | Blog

  3. #3
    Join Date
    Nov 2006
    Posts
    4

    Questions!

    Thnks for your help.

    The maion form has

    Cust Name details etc
    Phone make , model IMEI
    Date sent

    And also a section for choosing the loan phone that was isussed to them.

    Loan No - Loan TD Number, i.e number used to identify in fleet.
    Make
    Model
    IMEI

    i want it so that once loan no is chose in a combo box the rest is filled in and added to the curremt record, is kind of a lookup i guess.

    The loan Number is unique, is not a phone number.

    Thanks again

    Wez

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Oh I see!
    It sounds like you need to take a look at the DLookup function
    George
    Home | Blog

  5. #5
    Join Date
    Nov 2006
    Posts
    4
    ok where would be the best place to research that?

  6. #6
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    This is often the best starting point
    OR
    In MSAccess help files! (now you know what to look for, they're actually really good!)
    George
    Home | Blog

Posting Permissions

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