February 13th, 2010, 08:05 AM
MS Access 2007 - Linking subform with multiple queries
I have a table of song attributes, a table with Event details, and between them is a table that links several Song ID's to an Event ID with other fields that are specific to the event (like song order)
For flexibility, I always have a query between a table and its form so I can change what I want to see.
I want to be able to create a form that shows the song attributes at the top, then a subform that has the date of each of the events the song has been performed, along with other event-level data. I don't know why this is so hard for me to figure out - I've done plenty of forms and subforms before, but this one doesn't seem to be working. I created the proper relationships between the queries. Any suggestions?
Click Here to Expand Forum to Full Width