search funtion

[execution]

hi,

I have 8 tables with different information for the same ID. I would like to know how to create a search in a form so that when I type in that particular ID it will derive information from all the tables and list in text boxes in the form that i have created.

Any help would be much appreciated.
Thank you

 

[MarkK]

It's unusual to have 8 tables containing information for a single ID. Why can't that info be in one table, and save you having to look all over the place to find it back?
How are these tables related?

 

[missinglinq]

As lagbolt said, you do have to wonder about having that many tables based on a single ID. While we do stress the importance of normalization of data, some people, especially when they first begin to work with databases, tend to overdo this.

As a rule, an item needs to be moved into a separate, related table if there will be an unknown number of theses items.

If, for example, you have a table to hold personal information about an employee, you would include their social security number in the main table, because a person will only have one SSN.

But when it comes to storing that employee's contact phone numbers, you don't know how many they could have. They could have a home phone, a cell phone, and maybe one at their cabin on the lake! And so you'd have a second, related table, for contact numbers, realted to the main table by some unique field, such as an employee ID number.

 

[execution]

thank you for your input. im just starting to do access and im not at all familiar with what to do.