Hi
I cannot get my brain round a problem.
I have two tables, one for people, one for ticket numbers (for a random raffle/lottery). Each person will have multiple tickets.
I have a field in my people table which shows the date on which a person makes his last payment. If someone enters a value in this field, I want to change a Yes/No field called “Valid” in the Ticket field to show “no”. I have created a form (with a subform showing ticket numbers & Valid field) to do so, Set up a Leave event for the date field, but only manage to edit the first of the ticket nos, not all of them.
I really can’t think how to resolve this.
Can anyone help please.
Colin