I have a database I created to inventory machines we have here in our casino. I have a master table that I record all of the basic game data i.e. Serial #, Location, House # etc. This table is linked to other tables specific to each manufacturer of the game that contains firmware information.
The problem is I would like to implement a search function for users that enables them to call up a specific machine by typing in the machine number, and display both the information from the master table as well as the firmware table for that specific manufacturer.
As of now I can search the master table, but this does not display the firmware information from the other table that I need. I can create a query that displays all of the information, but I can only do a search on each manufactuer, that leaves me with a menu containing 19 different search buttons, one for each manufacturer.
Is there any way to have the initial search plug in the relavent data to the second query and then call up the data based on the original search result of the manufactuerer? Sorry if this is to complicated, let me know if you need any clarificaton and I will try and explain more. Thanks for any help.
Do you want it into a datasheet view? If so just go into the design view of this query and hit 'add table' in the toolbar. Add the other tables you want. Then drag the fields (or type in the fields) you want. Then in the criteria field under the Machine number field and type [something] i.e, [Enter Machine Number] Now when an user runs that query a message box pops up asking what machine Number they want.
I do have search functions now for the reports. The problem is I have to run a seperate query for each manufacturer. This is because I keep the firmware tables seperate from the main table. I want to try and consolidate all of this and create a search function that will call up any of the games with the firmware information on a report.
I need to find a way to forward data to a query "behind the scenes" so to speak, and open the report with that data. I am just trying to find out if access is capable of doing this.