Results 1 to 3 of 3

Thread: Access newbie

  1. #1
    Join Date
    Apr 2003
    Posts
    59

    Unanswered: Access newbie

    I know this is really simple but I'm struggling so if anybody could help me I'd be grateful. As a self-taught user of Access I understand too many of the details and not enough of the basics!! I just need an idea for a basic design of relationships and queries to process the following data:

    table 1: a list of potential suppliers, each in a country
    table 2: a list of customers and their details

    I need to select one and only one supplier from each country for each customer, in order to perform some calculations that multiply values in table 1 by values in table 2, to come out with a total price for each selected supplier for the customer.

  2. #2
    Join Date
    Feb 2002
    Posts
    403
    I am a little confused by
    perform some calculations that multiply values in table 1 by values in table 2, to come out with a total price for each
    But the table structure could be something like:

    tlkupCountry
    CntID
    Country

    tblSupplier
    SuppID
    SupplierName
    CntID

    tlkupContact
    ConID
    Contact(Phone, fax, email)

    tlkupContactType
    CTID
    Type (Supplier, Customer)

    tlkupAddType
    ATID
    AddressType (Main Office, Home, etc)

    tblAllContact
    ACID
    Type
    SuppID or CustID
    CTID
    Detail

    tblAllAddress
    AAID
    Type
    SuppID or CustID
    ATID
    StreetNumber
    StreetName
    Suburb
    CntID

    I have not detailed the customer table but I think this gives you a good idea where to start from

  3. #3
    Join Date
    Apr 2003
    Posts
    59

    Cool

    Thanks for the answer. I've decided to do it differently now by exporting everything into excel to do my calculations (and am now running into bugs in Microsoft Query! but never mind).

Posting Permissions

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