This is what I would like to do and don’t know the best method:
1. I have one table named “tblReferrals”. This contains a primary field called ReferralID. It also has a yes/no field of “Scheduled” (meaning scheduled for next term).
2. I have a second table named “tblClassAndQtr”. Which has a field ReferralID from above table, as well as a QtrID field. (from another table).
I am creating a form, called "frmAddNewQtrToAllScheduled" where one can choose a specific QtrID. This field on the form is called “MyNextQtrID”. Then, after pressing the confirm button, I’d like to have some code that--
Only IF the "Scheduled" field on TblReferrals, is true, then…
Adds records to the second table, tblClassAndQtr, and for each new record then inserts the related ReferralID from the tblReferrals, and the MyNextQtriID from the form into the QtrID field.
I am not sure how to begin doing this, am kind of a novice although am good at using code examples, and any assistance appreciated. Thanks!