I am looking for views on a matter that must arise for all Access developers.
I create systems (smallish) that usually have a central "master" table that is linked to multiple lookup tables (via Combos)
For example; I might create a "Car" table and I would have combo lookups for
1. Car manufacturer
2. Country of Origin
3. Car Colour
Therefore , every time I create a new database I also create numerous lookup tables and numerous lookup forms. The structure of both the tables and the forms are almost identical in every case.
Is there a better way?
E.g. Perhaps I should create ONE table and ONE more clever lookup. Or would this complicate matters?
Any views - or am I just being lazy !