Creating a Air Freight Rate Table Database

V

Vidhushi

Hi All,

I have been tasked to create a database for Air Freights.
Here is an example.

Tables I currently have:
Unit of Measure
Port of Export
Foreign Ports
Air Carriers
Tariff Table ( i.e. This is Matrix used my Air Carriers to
determine rates (1-10 Pounds) (Baltimore to Saudi Arabia)
(100 Dollars)

How should I design the structure of the database so that
we could:
SELECT PORT OF EXPORT, SELECT DESTINATION PORT, CHOOSE AIR
CARRIERS WITH THE ABOVE MATRIX AND DETERMINE THE CHEAPER
RATE) FROM EACH AIR CARRIER.

PLEASE ADVICE
THANKS IN ADVANCE
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form creates unwanted rows in table 1
Passing the output of a query to a table 4
Tip: Table design and query for bracketed lookup 12
Export selected tables from old Access Database to new Access Database 1
Automating Table, Form & Query 2
Lookup Table Field Retrieval / Separating Databases 1
Archiving tables (export several tables to a new database) 3
Database to Track Projects 2

Top