Access - display data from related table
Posted on 2012-08-21
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.