Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. #16
    ssanfu is offline Master of Nothing
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I've been thinking about your project and it seems like you want to pick a few options and be shown some rates as opposed to keeping track of specific containers.


    So basically, you have 3 rate tables: FRT_table, which is your basic rate depending on Carrier Contract, Contract type, POL, POD and Cost Code.
    Then an FRT_Additionals_Table that only depends on the Carrier (and Cost Code).
    Last is a Locals Table that depends on the Carrier and POD.
    Click image for larger version. 

Name:	TableRates1.png 
Views:	11 
Size:	24.5 KB 
ID:	44975


    Here are my suggestions:
    Click image for larger version. 

Name:	TableDesign1.png 
Views:	13 
Size:	48.5 KB 
ID:	44974
    I split POL and POD Ports into two tables here, but I would have both in one table with an additional field for showing which ports are POL and which are POD (the Port type).



    Here are the 3 rate tables
    Click image for larger version. 

Name:	Sturcture1.png 
Views:	13 
Size:	64.3 KB 
ID:	44976

  2. #17
    stildawn is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Oct 2013
    Posts
    185
    Quote Originally Posted by ssanfu View Post
    I've been thinking about your project and it seems like you want to pick a few options and be shown some rates as opposed to keeping track of specific containers.
    So basically, you have 3 rate tables: FRT_table, which is your basic rate depending on Carrier Contract, Contract type, POL, POD and Cost Code.
    Then an FRT_Additionals_Table that only depends on the Carrier (and Cost Code).
    Last is a Locals Table that depends on the Carrier and POD.
    Click image for larger version. 

Name:	TableRates1.png 
Views:	11 
Size:	24.5 KB 
ID:	44975


    Here are my suggestions:
    Click image for larger version. 

Name:	TableDesign1.png 
Views:	13 
Size:	48.5 KB 
ID:	44974
    I split POL and POD Ports into two tables here, but I would have both in one table with an additional field for showing which ports are POL and which are POD (the Port type).



    Here are the 3 rate tables
    Click image for larger version. 

Name:	Sturcture1.png 
Views:	13 
Size:	64.3 KB 
ID:	44976
    Thanks ssanfu, yes you have it correct, the tool is only used as:

    1. Sales team to get base costs to quote clients, so they find the base cost and add margin etc for quotes
    2. Invoicing team to check that Carriers charged us correctly

    No active tracking of any shipping, purely a cost calculator.

    I would note that the FRT_Additionals needs to have a POL and POD too, it doesnt in the current program but the redesign needs to have that.

    Also needs a Transits table, but that is simple to add to your design above.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 232
    Last Post: 04-17-2017, 01:08 PM
  2. Replies: 12
    Last Post: 03-14-2017, 04:43 PM
  3. Table Design - Relationship Structure
    By djspod in forum Database Design
    Replies: 2
    Last Post: 03-09-2017, 10:43 AM
  4. Replies: 3
    Last Post: 07-02-2015, 09:15 AM
  5. Complex Survey: Table Structure Design and Normalization
    By kevin007 in forum Database Design
    Replies: 2
    Last Post: 07-06-2010, 09:21 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums