Hm, been a while. Relational database. CustomerID/Name/contact info in one, another that has training information types, finally one that ties it together with CustomerID and training information types, date of training and other unique event specific information,
Then you have a form which uses DLOOKUP function to grab the info from the customer table and from the training type for a nice drop down or combo-box, and it inputs into the 3rd table which has all the information in it.
The form could be made in the standard CRUD format.
My Access is still Ancient 2K but I’m assuming it hasn’t changed much. If they have an “Address BooK” or “Customer Sales” Sample database, you can probably use that and change field names.
XMA Header Image
Create, read, update and delete – Wikipedia


Leave a comment

Your email address will not be published. Required fields are marked *

+ 7 = ten

Leave a Reply