I'm having an interesting issue. What I need is to track inventory of tickets by starting/ending numbers. I would have one field for starting out, ending out, the calculation of issued (ending out - starting out + 1), the starting returned, ending returned, calculation for that total (also ending - starting + 1), and the total usage (issued - returned). That's already 7 fields, and I want to have 10 of these I can keep track of per cashier. Couple that with the different types of tickets that can be sold, and I'd have a table with over 500 fields. That can't be the best way, and our work computers are slow enough, so I want to split up the tables. How do I maintain the relationship between the different types of tickets but still all related to the one cashier as if one record? I'm asking this on the form forum because I ultimately want to type in usage for all tickets per cashier and move between each cash register's sales with the record selectors.