I have a many to many relationship between Clients which have specific attributes
and Contacts which are mostly made up of relatives of the client and their contact information.
I almost immediately get the Spouse to become a client and will then share
many of the same Contacts. Later down the road other family members may become
Clients and also share many of the same contacts.
I don�t really want to have to input all their contact information
for each client if I already have them in the database. so I need to relate
various clients to various contacts or individual contacts.
I set up a client_contact m&m table and then connected the clients and contacts
on a one to many relation as is suggested in help but reading a little further down the
help file you get alpha can't display in forms or browse these sets but xbasic can do something
with them.
so I need to associate Clients to Contacts so I can say these contacts are for this client.
I tried to look at the school to classes template but I don�t really understand what they are doing there
and that is usually a classic display of a many to many there they split the connection between students and m&m table
and classes at least thats what I think is going on not the same way a m&m is shown in help.
I am thinking I need to set up some kind of header file or something of clients to contacts or what?
Any help on this Many to Many Idea and how to handle it in Alpha would be greatly appreciated.
I really want to know how you use an many to many relationship in alpha if you can�t display the set.
Thanks
and Contacts which are mostly made up of relatives of the client and their contact information.
I almost immediately get the Spouse to become a client and will then share
many of the same Contacts. Later down the road other family members may become
Clients and also share many of the same contacts.
I don�t really want to have to input all their contact information
for each client if I already have them in the database. so I need to relate
various clients to various contacts or individual contacts.
I set up a client_contact m&m table and then connected the clients and contacts
on a one to many relation as is suggested in help but reading a little further down the
help file you get alpha can't display in forms or browse these sets but xbasic can do something
with them.
so I need to associate Clients to Contacts so I can say these contacts are for this client.
I tried to look at the school to classes template but I don�t really understand what they are doing there
and that is usually a classic display of a many to many there they split the connection between students and m&m table
and classes at least thats what I think is going on not the same way a m&m is shown in help.
I am thinking I need to set up some kind of header file or something of clients to contacts or what?
Any help on this Many to Many Idea and how to handle it in Alpha would be greatly appreciated.
I really want to know how you use an many to many relationship in alpha if you can�t display the set.
Thanks
Comment