I have managed so far to create numerous tables, queries and forms to view and edit data, but the one thing I am completely stumped on is getting the right information based on two criteria to appear.
I have two database files:
What I have been able to do is create a form that when you type in the Asset Number, a list of all Work Order numbers appears in a sub-form, with a datasheet view of all the available work order numbers and a summary of information. I can then double click on the work order number and it opens up another form with extended data about the work order. However, this is still just a summary of the work order. What I need next is to break out what I will call "Modules", which are specific parts of the work order. Examples of these modules are:
In total I will have 10 of these modules (each it's own table), and I need to be able to have information shared from the main tables to these modules and back.
So the thing I am stumped on right now is being able to have a form that when I type in the Asset Number, instead of having it pull a query of all work orders numbers with a summary, I simply just want a list of corresponding work order numbers to show up in a combo box to choose from. Once the Asset Number and Work Order numbers have been chosen, then I can use navigation buttons to jump back and forth between the modules, without having to keep doing a search for the Asset and WO number combos.
So let's say a mechanic is working on a specific module, in order to get there he first has to type in the Asset Number, choose the correct WO number, then he would then just be able to jump to that module, make the changes, and have it reflect back on the summary page.
I have tried numerous methods to get this to work, and the only success I have had is in either a list of all work order numbers, or a blank list. I can't move forward with creating navigation buttons to the modules unless I get this piece to work first, so I am at an impasse at the moment.
So, my first question is, can anyone suggest the best practice to make something like this system work? Should I be using text boxes, lists, combo boxes, or perhaps something else I have not thought of or know about? Perhaps there is a tutorial out there that I have not found (believe me I looked) that might give me some step by step instructions that could aid me?
Any help or direction will be enormously appreciated.
I have two database files:
- Assets - This is where I track all information pertinent to just the assets (vehicles).
- WorkOrders - Each Asset will have multiple work order numbers. These are Autonumber generated.
What I have been able to do is create a form that when you type in the Asset Number, a list of all Work Order numbers appears in a sub-form, with a datasheet view of all the available work order numbers and a summary of information. I can then double click on the work order number and it opens up another form with extended data about the work order. However, this is still just a summary of the work order. What I need next is to break out what I will call "Modules", which are specific parts of the work order. Examples of these modules are:
- Brakes
- Transmission
- Engine
- Powertrain
- Etc...
In total I will have 10 of these modules (each it's own table), and I need to be able to have information shared from the main tables to these modules and back.
So the thing I am stumped on right now is being able to have a form that when I type in the Asset Number, instead of having it pull a query of all work orders numbers with a summary, I simply just want a list of corresponding work order numbers to show up in a combo box to choose from. Once the Asset Number and Work Order numbers have been chosen, then I can use navigation buttons to jump back and forth between the modules, without having to keep doing a search for the Asset and WO number combos.
So let's say a mechanic is working on a specific module, in order to get there he first has to type in the Asset Number, choose the correct WO number, then he would then just be able to jump to that module, make the changes, and have it reflect back on the summary page.
I have tried numerous methods to get this to work, and the only success I have had is in either a list of all work order numbers, or a blank list. I can't move forward with creating navigation buttons to the modules unless I get this piece to work first, so I am at an impasse at the moment.
So, my first question is, can anyone suggest the best practice to make something like this system work? Should I be using text boxes, lists, combo boxes, or perhaps something else I have not thought of or know about? Perhaps there is a tutorial out there that I have not found (believe me I looked) that might give me some step by step instructions that could aid me?
Any help or direction will be enormously appreciated.