views:

23

answers:

0

I want to build a simple app (probably in MS Access) for a simple small-business database. We have fairly typical entities -- customer, contact, worker, supplier, sub-contractor. These are all variations of some hypothetical parent class, e.g. person. Is it worth it to try to reflect this hierarchy in the tables and forms used by such an app? How would we do that? Master table of people with extension tables for each category related to it? Form for people with some kind of sub-form for the extensions? Or just forget all that and code similar but different forms and tables for each specific kind of entity? This is definitely not worth major amount of work or rocket science. Any standard solution out there that I can follow to get a little extra bang for the buck?