Results 1 to 7 of 7
  1. #1
    jimradio is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2018
    Posts
    4

    Volatile List of Categories to Choose From

    I have a feeling this is either going to be too complicated to do or it's so ridiculously simple to do that I'm just missing it. So any help you can offer would be greatly appreciated! Here's what I've got:

    I'm creating a database to help manage tools used at a given workstation. I've got a few dozen workstations, each with different configurations (for example mechanical assembly, electrical assembly, and product support). Each workstation would require different tools based on its configuration. For example, a mechanical assembly workstation would require tools like torque wrenches while an electrical assembly workstation would require soldering irons.

    I have a table set up for each workstation with it's ID number, the employee ID of the person working at that station, they type of workstation it's set up to be, and the location of the workstation. I have another table set up to list each tool required at each type of workstation (two fields: "jctTypes" for the type of workstation and "jctToolTypes" for a generic description of the tool required, i.e. "Soldering Iron", "Torque Wrench", "Digital Multi-Meter", etc.). I have a third table set up with a list of tools available with a number of different fields including Tool ID, Manufacturer, Model, Tool Type (the same generic description used in "jctToolTypes" mentioned before), and a few measurements to help determine ESD classification. Finally, I have a fourth table set up to be a junction table (three fields: "jctBenchID" for the workstation ID, "jctToolID" for the tool ID number, and "txtToolStatus" indicating whether the tool has been ordered, installed, or is out for calibration).



    My question is this: How would I create a form that could help combine all of this information? I'd like to be able to choose a workstation ID number from a combobox, have it list all of the generic tool descriptions required for that workstation based on the workstation type, and allow me to choose a tool from each category (that is, a list of all available torque wrenches for the "Torque Wrench" category or a list of all available DMMs from the "Digital Multi-Meter" category).

    I'm pretty proficient in VBA, so I won't shy away from some code and I'm very open if there's a more efficient way to organize my data assuming it will help me accomplish this task.

    Thanks!

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    you should use 1 table. All workstations are in it. (you can combine them)
    set the PC for the user ,to use that 1 station. (i use a tConfig local table)
    another table tWsTools, you would assign the tools to that station. pulled from the tTools table?

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Welcome.

    I suggest you show us a jpg of your tables and relationships.

    What is ESD classification?

    Have you tried to "mock up" a form to show the information? Once you know what the form will contain/display, you can work back to the source of the info and devise queries etc to get the data.

  4. #4
    jimradio is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2018
    Posts
    4
    Thanks!

    ESD Classification is just a way to determine how dangerous a tool would be around parts that are sensitive to electrostatic discharge. It doesn't really apply to this particular conversation - I just mentioned it to state that there was additional information in the tools table.

    Relationship diagram below. Hope that helps!

    Click image for larger version. 

Name:	Relationship Diagram.jpg 
Views:	11 
Size:	150.1 KB 
ID:	33059

    As far as creating a mock-up form, here's a basic layout of what I'd like to have:
    Click image for larger version. 

Name:	Form Layout.jpg 
Views:	11 
Size:	184.2 KB 
ID:	33060

  5. #5
    Join Date
    Apr 2017
    Posts
    1,673
    Quote Originally Posted by orange View Post
    What is ESD classification?
    For tools, generally it shows how prone is the tool to cause electrostatic harm.

    For some workstations, the worker has to wear special clothing, headwear and footwear, to wear grounding bracelets on feets/hands, etc. because of ESD rules.

  6. #6
    jimradio is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2018
    Posts
    4
    Quote Originally Posted by ArviLaanemets View Post
    For tools, generally it shows how prone is the tool to cause electrostatic harm.

    For some workstations, the worker has to wear special clothing, headwear and footwear, to wear grounding bracelets on feets/hands, etc. because of ESD rules.
    Bingo! You got it!

  7. #7
    jimradio is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2018
    Posts
    4
    ranman256, I'm not sure I understand what you mean. Could you sketch out your solution somehow, please?

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

Similar Threads

  1. List box to choose which form to open
    By MFS in forum Programming
    Replies: 2
    Last Post: 09-05-2014, 08:23 AM
  2. Design Question - volatile info and history
    By crimedog in forum Access
    Replies: 3
    Last Post: 01-07-2014, 12:03 PM
  3. Replies: 3
    Last Post: 08-29-2010, 06:34 AM
  4. Replies: 0
    Last Post: 12-14-2009, 09:57 PM
  5. Replies: 3
    Last Post: 09-26-2009, 01:57 PM

Tags for this Thread

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