Can i branch off in microsoft access? Have multiple items?

[ProdigyOne]

I was wondering if i could make something like this...
Look at this like Cells in Excel/Access

AutoNumber Date Name Address City State Zip Phone number Fax Number
Phone number
Phone number

Basically i want all of those "phone number" cells to still be related to whatever the "autonumber" is. Every instance creates a new number, and i want to be able to store more than one item in the phone number without having to make a whole new row of stuff. Anybody know how i can make this happen?

Thanks a ton for any help given!

 

[Andrew Fergus]

Hi

It sounds like you want many phone numbers for each contact / client / supplier / whatever. This can be achieved a couple of ways. One way would be to have 3 or 4 phone number fields for each record within the table by creating more field names with names like "Phone_Number_2", "Phone_Number_Mobile", "Phone_Number_Work", "Phone_Number_Home" etc. This is the simplest way.

Another way is to have unlimited phone numbers for each entry in the table by creating another table which stores the contact id & telephone number. This table would link to the original table with a one-to many relationship on the contact id. This way one contact can have many telephone numbers. This way is more complex and may be more than you are looking for. For help on 'normalising' a database with one-to-many relationships, have a read of this webpage.

HTH, Andrew.

 

[ProdigyOne]

THANKS!
Great idea...man i love this message board, you guys are so helpful!