Results 1 to 3 of 3
  1. #1
    Join Date
    May 2013
    Posts
    2

    Unanswered: MSAccess2013 - Tables

    I have a pricelist in MSExcel with 17 sheets and I have created the tables according to the fields in MSExcel.
    Normally each worksheet contains a model number with peripherals (up to 30 different peripherals) for the particular model number.
    My problem and I need some suggestions please or an example will be appreciated...
    Some of the sheets however contains 2 or 3 model numbers but they use the same peripherals.
    When I build the form I want to select the model number and then the peripherals for the specific model must be display in order for me to select the peripherals for the specific quote.
    Pricing change on a monthly basis and new model being added and old models being deleted - I can change the excel workbook manually but then I just create more pain.
    How would I go about this?


    Let me give some more information because I've got 30 odd models with different peripherals ie normally one model will have 1 and up to 30 peripherals. It can also happen that more than one model uses the same peripherals as another model.
    Example:
    Model=AF1000
    Peripheral=ABC230
    Peripheral=VFR200
    Peripheral=KME334
    Peripheral=LOP100
    Peripheral=SEP555

    In my form I want to select the model and then the peripherals must be displayed in order for me to tick the peripherals which I want to add.
    Example:
    Model=AF1000
    Peripheral=VFR200
    Peripheral=LOP100

    I'm looking for a way to link the peripherals to the model number in order for the dropdown to display only the peripherals associated to the specific model number?

    Any help or an example will be appreciated.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    sounds like you want to shift the whole thing from Excel into a db
    define products
    define peripherals
    define what peripherals are compatable with which products (an intersetion table)
    if you are clever about it define which peripherals are not compatable with others, or is its easier which peripherals are compatable with others

    the design your input form sung combo boxes and populate them as required ie pull in all peripherals relevant to the selected model
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    May 2013
    Posts
    2
    Correct, I want to move the pricelist from excel to msaccess in order to build a proposal system. I've got 30 sheets, each sheet contains it's own model number with its own set op peripherals. In some of the sheets you may get up to 3 different models which use the same peripherals. I'm looking for a way to link the peripherals to the model numbers in order to select a model number and then the peripherals must be displayed. I will then tick the peripherals which I want to add to the selected model number.

    Please try and help me with an example?

Posting Permissions

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