I ran into a bump in the road and I'm looking for some advise.
I need to populate a form with data in a cross tab format. I have the header which holds fields universal to all the records, and the detail will be the individual records.
My source table has three fields
Series, Item, Attribute, Data
Each item has multiple attributes and data records so one item will have as many records are there are different attributes.
I also have a table that holds two fields, Series and Attributes.
I'm thinking I can build a form that when a series is selected, all the matching attributes populate. I'd than like to check the attributes I want included in my query, and fire off the query. So, if I select the series Magna1, I should see attributes a1, a2, a3. Once I select a1 and a2 as my attributes, I than want the query to generate and display all the items in the Magna1 series with their a1 attribute, a1 attribute data, a2 attribute and a2 attribute data.
Finally, I need to populate a table or output to excel these pieces of data.
To be honest, as I write this, I can't even begin to phantom how I might do this...it's making my head hurt. Any suggestions or examples are appreciated.