I do want to thank all of you for your help.
Mary's hint about using dates is very interesting. It solves the distribution problem I have yet had time to consider.
I have already built the two tables as ADezii suggested using SSAN. Wrote about 30 quarries and as many forms trying to figure out how to post the data base - once I gave up on building everything around the tblTickets table and starting focusing around...
dbnut
Last Activity: Feb 4 '07, 01:35 PM
Joined: Jan 30 '07
Location: Sealy TX
-
I do have two child tables as described but linked them by ticket #
1. Issued Table: ticket # , FirstName , LastName
2. Sold Table: ticket # , SFirstName , SLast Name
My Parent ticket table: Ticket #, issued (y/n), sold (y/n), deposited (y/n).
I am sure that I do not need both child tables if I understand the logic.
The idea is to track who I issued tickets to - who the ultimate...Leave a comment:
-
Duplicate text box entries into multiple records on same form
• I am using Access Trial 2007 in 2003 Mode.
• I designed a Form to track what tickets still need to be issued
using a split form:
_______________ _______________ __________
Ticket 14 First --------- Last ----------- Issued (n)
_______________ _______________ ____________
Ticket # ---First----Last-----Issued
14 ----------|--------|----------|----- (n)
15 ----------|--------|----------|-----...
No activity results to display
Leave a comment: