Or simply have a CustType field in your table that requires a C or R and let your form validation control what is put in there. I see nothing wrong with the instructor teaching about lookup fields as long as he/she covers the pitfalls. http://access.mvps.org/access/lookupfields.htm
I've only ever used them once; to control the user level option that can be set for the user (an actual custom database object) within the db. It was never intended to be queried or reported on.
Make sure you're talking about lookup fields and not multi value fields.
Last edited by Micron; 02-03-2016 at 09:58 PM.
Reason: added link
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.