Elmobram22
Registered User.
- Local time
- Today, 23:42
- Joined
- Jul 12, 2013
- Messages
- 165
Hi all,
I want to make a database of contacts with email addresses and telephone numbers. And I want to assign them to groups but I want them to be possible to be assigned to multiple groups. Basically so I can write an email and send it to the group I want to but then get access to send only one email if they are in multiple groups I choose. I'm wondering the best way of setting the tables up. I'm thinking along the lines of TblContacts, TblGroups and TblAssign. In the TblAssign I would have a fk for the IDs of both contacts and groups but I don't know whether this is an overbloated way of doing it. Any suggestions would be greatly appreciated.
Cheers,
Paul
I want to make a database of contacts with email addresses and telephone numbers. And I want to assign them to groups but I want them to be possible to be assigned to multiple groups. Basically so I can write an email and send it to the group I want to but then get access to send only one email if they are in multiple groups I choose. I'm wondering the best way of setting the tables up. I'm thinking along the lines of TblContacts, TblGroups and TblAssign. In the TblAssign I would have a fk for the IDs of both contacts and groups but I don't know whether this is an overbloated way of doing it. Any suggestions would be greatly appreciated.
Cheers,
Paul