Results 1 to 3 of 3
  1. #1
    rossp0203 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2011
    Posts
    1

    Database to produce quotes


    I am currently working for a company and they need to me to create a database of all of their products along with the information relating to those products, so that i can then go into the database with a clients specifications and the resulting products which fit their specifications would be highlighted and filtered out. Once choosing a primary component such as a pump it is then wanted that a list of say engines/tranmissions/valves which can relate to that particular pump would then be displayed. Each component can then be chosen or ticked to create a final quote.
    I dont know how complex this would be but i know exactly what they want just not how to do it, any help would be greately appreciated, and if you need more info i can try my best to explain.

    thanks

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    This is a good place to start

    http://www.accessmvp.com/strive4peace/

    Alan

  3. #3
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    I think the answer is that it is both complex and yet routine if one designs databases.

    One needs a clear understanding of the components/products relationships with sufficient real samples that one can then properly cross reference the two. Because a Product is made up of multiple components. And a component can be used by multiple products. They are two separate tables. You then have a 3rd table that set up the cross reference: i.e.

    Prod1 Comp1 Qty 2
    Prod1 Comp2 Qty 1
    Prod1 Comp3 Qty 5

    you get the idea.... first you have to block out the concept - - and then the grunt work to enter that data begins.

    Hope it helps.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 13
    Last Post: 10-12-2011, 11:08 AM
  2. Problems with Recordsets when items contain quotes.
    By caddcop in forum Programming
    Replies: 6
    Last Post: 05-17-2011, 07:49 AM
  3. Replies: 0
    Last Post: 03-30-2011, 09:50 AM
  4. Replies: 1
    Last Post: 12-21-2010, 09:27 AM
  5. Remove Quotes within Data Values
    By kfschaefer in forum Programming
    Replies: 0
    Last Post: 02-26-2009, 01:15 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums