Hello everyone! I'm new here, so go easy on me ;-) I have a pretty good skillset with VBA for Excel, but now I'm venturing out into Access. So if the solution I'm looking for requires VBA (and I'm sure it will), a little extra TLC would be greatly appreciated.
I have a table (AccessCodes) with three fields: AccessCode (PK), Available(Boolean), and ActivateDate. All AccessCode values are unique. I use this table as a lookup table for my main table which is called "EligibleCustomers".
As each record is added to the EligibleCustomer table, I would like Access to automatically assign the customer the next available AccessCode in the lookup table.
I would imagine that it first start with making a simple SELECT query on the Lookup table with Available = True. The query would then be used to link to EligibleCustomers as its lookup source.
The procedure I'm unsure about is how to automatically assign the next available AccessCode to the customer, and then mark the AccessCode's Availability to False.
Your helps is greatly appeciated. Thanks.