Good morning all,
I'm sure this will take some little tricks to pull off - if its possible. I have 3 tables that contain build/configuration data for computer systems. 1 is back information, 1 is front information, 1 is peripheral information. all can be joined by one field or another.
Is it possible to have a form, that allows users to maybe select ( radio button) certain fields and have the query run against the data they provide? I know I can do this with many different queries and 1 buttom for each query on the form. 1 person may want to search for "compact flash cards" within a date range, while 1 person might want to search for "hard drives" with a certain lot number. someone may want to search for displays beginning with "K2" only.....
or maybe other ideas?
Thanks
Kevin
I'm sure this will take some little tricks to pull off - if its possible. I have 3 tables that contain build/configuration data for computer systems. 1 is back information, 1 is front information, 1 is peripheral information. all can be joined by one field or another.
Is it possible to have a form, that allows users to maybe select ( radio button) certain fields and have the query run against the data they provide? I know I can do this with many different queries and 1 buttom for each query on the form. 1 person may want to search for "compact flash cards" within a date range, while 1 person might want to search for "hard drives" with a certain lot number. someone may want to search for displays beginning with "K2" only.....
or maybe other ideas?
Thanks
Kevin
