Complex UNION query needs info from another table

[LisaOnMSN]

I'm fairly new to Access: Does anyone know how to connect the following information in query form? I have a table (park) connected to many feature tables via parkID (as a foreign key in each of the feature tables: sigh, fence, building, road, etc). parkID is a primary key in the park table and autonumbered.

I thought since I had connected the tables in this way, it would be fairly straightforward to use a query to determine which features exist for each park, since the main table and the feature tables had this common key. Wrong. I have at least managed to create a union query that indicates when a feature exists for a park by a simple union on the parkID for each feature table BUT since the park name isn't in each of the feature tables (only the parkID) this query does no good at report time: the parkID isn't the park name, and I haven't found a way to include this in the query. The query is attached.

Lisa

 

[stopher]

All features should be stored in one table, not several tables. Then your query becomes trivial.

hth
Chris

 

[LisaOnMSN]

The information I've been asked to store for each of the feature types is dissimilar, (since an irrigation system is not a playground, is not a swimming area). On the form, I dealt with this by using a drop down list of the features and swapping them out into the same source object.

Thank you for replying.

 

[stopher]

That's a reasonable enough reason.

Just save your Union query. Then create another query and use the Union query as the source. In this new query you can add the extra tables and joins you require in order to give you a data source that contains all the associated data you need.

hth
Chris

 

[LisaOnMSN]

I'll try that, thank you.

Lisa