Results 1 to 2 of 2
  1. #1
    johnomar is offline Novice
    Windows 8 Access 2016
    Join Date
    Apr 2017
    Posts
    1

    Machine Parts Database

    Hi
    I want to design a database for a company that sells machine parts. Usually what I will do is create an orders table, customers table, products table and ordersDetails table. The orders table will store the customerID as a foreign key. The ordersDetails table will store the ProductID as a foreign key.
    Then I will create a form that uses the orders table as a record source and a subform inside the main form that uses the ordersDetails table as a record source. The main form is linked to the subform by the OrderID.
    When the user enters an order, he/she will start at the main form and selects the customer from a combo box (the orderID will be generated automatically). Then at the subform, the user will select the product from a combo box and enters the quantity in a text field, and will repeat the same steps for other products in this order(subform will be in a datasheet view).
    What I want to do for the machine parts database is that, after entering the OrderID and Customer in the main form, I want the subform to be an independent form (a button on the main form will open the new form) and on this new form their will be a thumbnail image of all the machine parts in my database. The user then clicks a thumbnail image of the machine part that he/she wants to be included on this order. The click on the thumbnail image will open a new form. On this new form their will be a large image of the machine part and a text box to enter the quantity of the machine part to be ordered. After the user enters the quantity, I want the order to be considered completed.


    Could anyone please give me some tips or hints on how to achieve this ?

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

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

Similar Threads

  1. Parts Database Theory.
    By Homegrownandy in forum Access
    Replies: 10
    Last Post: 11-14-2016, 08:27 AM
  2. Replies: 4
    Last Post: 11-27-2013, 09:51 AM
  3. Products and Parts Database
    By aesp533262 in forum Database Design
    Replies: 13
    Last Post: 11-11-2012, 08:07 AM
  4. Replies: 3
    Last Post: 08-02-2012, 11:37 AM
  5. Prohibiting access to parts of a database?
    By Delta223 in forum Access
    Replies: 1
    Last Post: 01-05-2011, 07:31 AM

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