How can I connect more than 30 tables/queries in an Access query, or accomplish the same result?
Posted on 2011-04-19
I have a database in which users can book schedules for their boats.
I was not very familiar with either access or VBA when i made the DB, so I think I got off to a bad start, and now I am stuck with the layout.
So I am hoping to find a way to make this work without having to make it all over.
There are currently 28 slots each day, and when a user selects their usernumber in a combinationbox, the rest of the information about the member's boat appears in the fields to the right of the number.
There are 2 main tables, one with all the slots and the membernumbers assigned to each (schedule-table), and one with all the information about the boat of each membernumber (member-table).
So what I did was to make 27 identical queries of the member-table, and related each slot in the schedule-table to a separate query.
This worked perfectly, until they just now asked me to add 4 more slots to the day.
I created 4 more queries, and followed the same procedure, but as I add number 31, I get "query too complex".
Is there anything I can do to add 4 more slots to the schedule, without too many hours of work?
I experienced with having one big query with many duplicates of the same fileds, which resulted in the query working but the form wouldn't let me put in any data.