One to Many
I have a 'Contacts' table and need to create relationships for each contact in that table. For example, Mary (primary contact) has a father (Fred), mother (Betty) and sister (Sue). I need to, while v...
Forum Discussion
You have the patience of a saint, I appreciate your time and expertise. I am a pretty highly educated and seasoned (euphemism for old) professional (in my field) and struggle feeling like a complete idiot in this regard. ARGH!
That said, I fear I have overly complicated what I'm trying to do. From the top, I have a table Contacts with let's say a record for Bob, Billy, Mary, etc. I have another table Connections. I need to be able to create relationships between these records int eh Contacts table. For example, a section on Bob's Main Contact Form called Connections that would show
Billy | Father
Mary | Mother
where values in the column with the names (Billy, Mary) would be hyperlinked to that values Main Contact form respectively. Furthermore, on Mary's Main Form the Connections section would display
Billy | Husband
Bob | Son
Is this a one to many relationship between Contacts and Connections as I've tried to set up here...
or perhaps a many to many between Contacts and Contacts and if it's the latter I have no idea how to set that up.
Can you help clarify, point me to an app that I can see an example of how to accomplish the above, or recommend a developer that I can contract with?
Again, many thanks...
That said, I fear I have overly complicated what I'm trying to do. From the top, I have a table Contacts with let's say a record for Bob, Billy, Mary, etc. I have another table Connections. I need to be able to create relationships between these records int eh Contacts table. For example, a section on Bob's Main Contact Form called Connections that would show
Billy | Father
Mary | Mother
where values in the column with the names (Billy, Mary) would be hyperlinked to that values Main Contact form respectively. Furthermore, on Mary's Main Form the Connections section would display
Billy | Husband
Bob | Son
Is this a one to many relationship between Contacts and Connections as I've tried to set up here...
or perhaps a many to many between Contacts and Contacts and if it's the latter I have no idea how to set that up.
Can you help clarify, point me to an app that I can see an example of how to accomplish the above, or recommend a developer that I can contract with?
Again, many thanks...