I am trying to set up a mailing list database and having 5 tables:
1. Customers with: customer_id, name, company, address, city, state_id (number), zip...
2. States with: state_id (autonumber), states_name
3. Services: services_id, services_name (Fedex, DHL, UPS...)
4. Shipping: ship_id, ship_date, ship_services, ship_tracking, good_type and good_quantity
My questions:
1. Someone please look at the above an tell me if the concept is right?
2.Theoretically, I understand this should be one-to-many, but I don't quite understand why when I open the relationship window, drag the state_id from table state to the state_id in customer, the relationship would not be what I expected, i.e. when I open the tables States, press the little plus and it shows no Customer data :banghead: What's wrong ? And how can I go around this situation?
Thanks a bunch
1. Customers with: customer_id, name, company, address, city, state_id (number), zip...
2. States with: state_id (autonumber), states_name
3. Services: services_id, services_name (Fedex, DHL, UPS...)
4. Shipping: ship_id, ship_date, ship_services, ship_tracking, good_type and good_quantity
My questions:
1. Someone please look at the above an tell me if the concept is right?
2.Theoretically, I understand this should be one-to-many, but I don't quite understand why when I open the relationship window, drag the state_id from table state to the state_id in customer, the relationship would not be what I expected, i.e. when I open the tables States, press the little plus and it shows no Customer data :banghead: What's wrong ? And how can I go around this situation?
Thanks a bunch