Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Undoing Table Relationship Ship.

Status
Not open for further replies.

Kjonnnn

IS-IT--Management
Jul 14, 2000
1,145
US
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?
 
Hi

Yes, it is called a query.

Make a query which joins the two tables together,

This will give a single recordset conatining all the firleds from both tables.

If you want to include customers with no products (or vise versa) right click on the join in the query degner and read the dialog box, then complete accordingly,

Then make then an enquiry screen based on the query. Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top