Unanswered: I'm having problems with Multi-Table JOINS
Access 2000 V9.0
I am trying to get my head around how to perform a multi-table query so that I can lookup descriptions in other tables in a single query.
I have an InventoryItems table that tracks Subdivision using a SubdivisionID.
I can't for the life of me figure out how to get the SubdivisionName from the Subdivisions table in my query that also pulls data from my main table (InventoryItems).
[ Maybe because it is Friday.....]
Below I have illustrated the tables/fields with sample data. I am not showing all of the fields for purpose of making this easier to envision. The unlisted fields are not used for filtering/linking.