Here's my situation.
I created a database for a department. I created two tables ... one for customer information and another for product information. The two table are related properly.
I also created a form for the user to enter information and where the product information is a subform of the customer information form. The users can just pull up the customer info and enter new product information at the bottom in the product subform.
I also created reports with parameters so that they can search for what ever they wanted to. Everything works as I have set it up.
Now after using this database for about 6 months, they want me to make it one big table instead of two. Here's why. They want to only have to search for items on the input form. They don't want to have to go to the Report view to search.
Presently, if they click in an area in the product subform to do a search ... it only searches the records in that subform for that particular customer. They don't wanna go to the Report section where I have it set up so they CAN search the whole database. They dont want to have to click from the FORM view to the REPORT view. Sigh.
So is there an easy way to combine the two tables into one big table easily so these people can have an easy life?
I created a database for a department. I created two tables ... one for customer information and another for product information. The two table are related properly.
I also created a form for the user to enter information and where the product information is a subform of the customer information form. The users can just pull up the customer info and enter new product information at the bottom in the product subform.
I also created reports with parameters so that they can search for what ever they wanted to. Everything works as I have set it up.
Now after using this database for about 6 months, they want me to make it one big table instead of two. Here's why. They want to only have to search for items on the input form. They don't want to have to go to the Report view to search.
Presently, if they click in an area in the product subform to do a search ... it only searches the records in that subform for that particular customer. They don't wanna go to the Report section where I have it set up so they CAN search the whole database. They dont want to have to click from the FORM view to the REPORT view. Sigh.
So is there an easy way to combine the two tables into one big table easily so these people can have an easy life?