Student Access user, need help creating a table

[racheliza79]

Hello!



I am new to Access, but I have a good understanding of how to use it and the terminology with creating databases.

For my class, I have a list of entities and their attributes. I have to create a table for each entity. No problem! I have completed this...almost.

The ONE table I am having trouble with is as follows....


VENDORS

Vendor ID
Name
Order address
Street
City
State
Zip
Order Contact
Order Phone Number
Order Fax Number
Billing Address
Street
City
State
Zip
Billing Contact
Billing Phone Number
Billing Fax Number

So, when I am creating this "Vendors" table, I'm not sure how handle the fact that there are two addresses. My professor says that the street, city, state, and zip for both of these addresses should be in their own filed (column). But we can't have duplicate attributes in one table. How do I accomplish this?

Thank you!!
Rachel

[racheliza79]

***field****

[ajetrumpet]

use your own naming conventions. it's that simple. like:

address_b
city_b
state_b
zip_b

address_s
city_s
state_s
zip_s 

hence, an identifier tagged at the end of fields to identify "shipping" or "billing" . these are not common conventions but that doesn't matter. make sure you know what you're doing, thats all you need. the users won't care anyway

[racheliza79]

I had a feeling it was that simple! Thanks!!