Building Access DB from Scratch (1 Viewer)

Hi,

I'm running my own business and looking to develop an Access DB to control my business. I'm a beginner and was stuck in building my first relationship tables.

I'm running a logistic business on international transportation. I have no idea how to build a database that will identify rates based on kilogram and country that they send to. All the countries in the world is divided into 11 zones.

Access need to identify the rate card and zones that customer is shipping. Each customer will have their specific rate card at different discount level.

My db will have few tables namely:

1.) Customer Contacts
2.) Order Details
3.) Products
4.) Rates - I have like 30 rates table.
5.) Country Zoning

I'm done with creating all the tables except for Rates, where I have like 30 rate card which was divided into 2 different products namely import and export.

Can someone help me on

1.) How to create 30 different tables under Rates group?
2.) Link the rates table to specific customers

Thank you.

Rgds,
Ryan

ryancho said:

1.) How to create 30 different tables under Rates group?

Click to expand...

No... ! Don't have 30 different tables.... I reckon you only need one.

Agree with Tony here, 30 tables with the same type of data? Sounds more like you need one table with a "Type" column.