Linking data fromp multiple tables

**shanej100** · 02-22-2011, 12:06 PM

I have a basic understanding of Access (or so I thought) but I'm having real difficulty figuring out how to resolve an issue I'm having.

I have a database which contains three main tables. The first has some basic employee information, the second contains details about offices in the building (like door code and telephone extension) and the third is a list of technology assets we have (like CPU's, monitors, printers, etc.).

What I want to do is to link employee info and technology assets to specific offices. Basically I would like to call up office #1 and have a nice form that would display who occupies that office, the number of their computer, and printer (if they have one), etc.

I can't, for whatever reason, get my head around how to bring it all together though....

Please help before I go insane!!!

Thanks

Shane

**ajetrumpet** · 02-22-2011, 04:07 PM

you need common fields, Shane. Once you get that down, it's very simple. Do you have a handle on that first?

**shanej100** · 02-23-2011, 07:14 AM

Hi Adam,

I think I do. On the table that has the employee info I have an employee number and I also have an employee number field on the main table as well. I made a relationship between those two fields. Is that what you are refering to?
Shane