Access - display data from related table
This is probably super simple to people who are good with Access and spend time working on databases, but I am not either of those, so sorry if I am explaining this poorly or if I have "designed" this poorly. It is outside of my comfort zone, but It was asked of me to build it anyway. What I have is a really simple access db that has 2 tables:
House (has HouseName = arbitrary name/address, ID = unique ID)
HouseInspection (ID=unique Id, HouseNumber=the unique Id from Hydrant table, and various other fields for keeping data)
So there is a 1 to many relationship of House to HouseInspection. The problem with that is when users pull up the data from HouseInspection, they get an ID, which is a unique ID that they don't care about, and HouseNumber, which is another unique ID that they don't care about. They only care about the name/address. So I would like to somehow display (not copy, if possible) the HouseName field somehow so that when users pull up the HouseInspection datasheet/table, they can see the HouseName (from the House table) without having to switch back and forth between the two tables looking up HouseName based on unique IDs.
This was built with Access 2007, if that matters.
House (has HouseName = arbitrary name/address, ID = unique ID)
HouseInspection (ID=unique Id, HouseNumber=the unique Id from Hydrant table, and various other fields for keeping data)
So there is a 1 to many relationship of House to HouseInspection. The problem with that is when users pull up the data from HouseInspection, they get an ID, which is a unique ID that they don't care about, and HouseNumber, which is another unique ID that they don't care about. They only care about the name/address. So I would like to somehow display (not copy, if possible) the HouseName field somehow so that when users pull up the HouseInspection datasheet/table, they can see the HouseName (from the House table) without having to switch back and forth between the two tables looking up HouseName based on unique IDs.
This was built with Access 2007, if that matters.
Scott McDaniel (EE MVE )
How are users "pulling up data"? Are they doing so through a Form, Report, Query, etc?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
like this quick and dirty sample
Database31.mdb
Database31.mdb
...alternately, you can create a form from the query as well...
This is very basic, so play around with it, so you understand how it works.
This is very basic, so play around with it, so you understand how it works.
ASKER
Thank you for the example, it was extremely helpful. I used the query wizard and it was extremely simple to make my query and select the exact data the users need.
;-)