Discussion Locked

Raffle Tickets

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I want to have it so that if some one pledges ?5 on one table. At the click of a button another table is updated with 5 tickets allocated to this person.

3 replies

by sgt_shultz

check out how this is done with the indispensible northwind.mdb sample database free for download from microsoft. the really necessary help file for it is located on the office install cd. worth finding...

by simonevans31

This does not help me to link the 2 tables, taking 1 record value and creating several records in another table

by frog66

table1.addnew (update fields with info)
table1!Amount = 5
lngID = table1!ID (get the autonumber of the table1 record for the link to table2)
table1.update

for i = 1 to table1!Amount
table2.addnew
table2!TicketID = lngID
table2!OtherFields = whatever
table2.update
next

1 record in table1 linked to many in table2. Many depends on value of Amount.

Hope this helps

This discussion is closed to new replies.