So I'm setting up a registration process for people to be able to register online for WebEx demonstrations. Session are limited to 10 each. I don't want the full sessions to appear in the drop-down on the page. I'm using 3 tables - the first one lists just the session id and session time/date, the second is a transaction table - listing transaction id and session id (figured I could get the count here?) and the third is the attendee info which includes registration date, session id, attendee info, etc.<BR><BR>What's the best way to get that count from the transaction table so that the session isn't in the drop-down? Keep in mind, it needs to join with the session table to pull in the time/date info... HELP! Am I making this more confusing than necessary???