I am making a back office/booking system for a coach tour operator. I am having trouble getting my head around seat plans. For each tour I need to record which passenger is in which seat on the coach. Should I create a 'seats' table for each tour or a table containing every seat in the database with the tour ID to identify the tour. Whichever way I go, the coach seat plan for each tour is the same until I add passengers so I don't want to have to key in every seat on every tour each time I create a tour. Make Table query or append query??? Once I have decided how to store the data and create the table I will have to get on to how to select the seat during the booking process and display the seat plan graphically on screen.
Anyone done anything like this can help. I am really not good with access but very keen!