Topic: Shared Address Table
Hi All,
I'm starting to get more comfortable with MVD. However as I progress I find myself wanting to do more. Probably to be expected.
-
Here's the overall goal of my program so you can see where I'm going. It will be a RECORD KEEPING program. There can be one or more USERS. Each user will be able to keep records about different things, such as CONTACTS, HOUSING history, MEDICAL RECORDS...etc.
-
Currently to begin with, I have 3 tables - USERS - ADDRESSES - CONTACTS (there will eventually be more tables like CONTACTS)
-
There can be multiple USERS and each one can have many addresses. A Current address and also previous addresses
-
A USER can have many CONTACTS. and a CONTACT can also have one address. Usually their current one.
-
I would like to have only one ADDRESS table where I can store all addresses. I don't think it sounds like good form to be creating the same address fields in the CONTACTS table, and the others to come later.
-
So I'm thinking ADDRESSES would be a shared table to be used by various categories.
-
It's this shared table concept that I'm having trouble with
-
It's also possible that my design concept is maybe not the best way to go?
-
Any ideas will be appreciated.
-
Thanks in advance. The help I have received from Derek and others on the forum has been fantastic.
-
Thanks, Frank (everyone please stay safe)