How do i create a table which supports multiple contact information details?
Such as Addresses, eMails), Phone Numbers and so on.
Way do i want a client table which can hold multiple phone numbers for a client or addresses?
Today it is very common we have 1, 2, 3 mobiles or several eMail addresses or tow apartments as an example. Then wouldn't it be logical if the database have support for this.
How would you design the table(s)?
How would you design the forms & queries?
tblClients
- ClientID
- FirstName
- LastName
- Address
- City/Location
- ZIP
- Phone
- Mobile
- DateOfBirth