setting up a relational database

access United States
  • 15 years ago

    I the following tables in my Access database:

    tblRun (has a user defined name for grouping manufacturing items for production)
    tblWorkOrder (actual items that will be grouped into each run via the tblRunSetup)
    tblRunSetup (contains foreign keys for run name (from tblRun), the items (from tblWorkOrder), and a quantity field for the number of items to make for each run. This table is where the actual runs will be created)
    tblWorkOrderLineItem (keeps track on how many of any given item per run is complete, with the site it is stored at, and the employee that did the work)

    My trouble is that I want to set up combo boxes in a Work Order Entry Form that will allow the user to select an individual run name and one of the corresponding items from the work order in separate combo boxes. However, the current way I have the tblWorkOrderLineItem setup only references the tblRunSetup through a single foreign key. I can't setup up two different combo boxes from a single foreign key, can I? How would I do this?

    Let me know if I am not making sense. I know it is difficult to read minds over the Internet, not seeing the actual problem.



Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Engineers are all basically high-functioning autistics who have no idea how normal people do stuff.” - Cory Doctorow