Shall I make a new table called something like tblContact or tblContactdetails and a) put the Email1, Email2, Company, Phone and Mobile in there, along with b) a foreign key CID referencing tblClient as a one-to-many relationship? Am I right in surmising that this is what you guys recommend?
Cheers--Leo.
Nothing near like that...
Table would have the following fields
ContactID............AutoNumber........Primary Key
Cust_ID..............Number...............Foreign Key to parent
ContactType........Text...................What type of contact is this?
ContactDetail.......Text...................What the contact really is
In your data it will look somewhat like this.
1...1....Phone....6064845586
2...1....Email.....Null@Null.Dev
3...1....Mobile....44588663355
4...2....Phone....8855115335
5...2....Email.....Andra.Test@null.Dev
So you can have as many different types of contacts related to a given parent records as you wish. No need to add extra fields for them, just add one record for each. That way when they decide "Crap, we need to add their mother-in-law's EMAIL address" you already have an easy way to store this.
Could even go so exotic as to have type and sub-type as two fields, since they store different types of data.
Remember, a contact is a contact is a contact, regardless of what "Type" it is.
YourEmail@YourISP.AU is just as valid as 995649840 for your home phone, 564980800 for your mobile, or
MotherInLawIsME@HerISP.AU. Type (and possibly subtype if you want to get really excessive) would be used to format numeric entries.