Please Help Me

Discussion in 'Databases' started by pushkar, Dec 8, 2006.

  1. #1
    Hello Guys.
    I very new in this section.
    I want to make one table in access but i m confused.
    I want to make table for shipping rates.
    Here i have attached pics of my form design.
    Can u please tell how should i design my table???
     

    Attached Files:

    • rate.jpg
      rate.jpg
      File size:
      23.2 KB
      Views:
      288
    pushkar, Dec 8, 2006 IP
  2. krakjoe

    krakjoe Well-Known Member

    Messages:
    1,795
    Likes Received:
    141
    Best Answers:
    0
    Trophy Points:
    135
    #2
    we could but then we'd need to explain how to use it, you're going about it all the wrong way, ode the application / script first, then produce an interface, at the very first stage of developing a database app is designing the database.
     
    krakjoe, Dec 9, 2006 IP
  3. tandac

    tandac Active Member

    Messages:
    337
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    58
    #3
    Table: ShippingRates
    - ID AUTONUMBER
    - COUNTRY CHAR(2)
    - MIN_WEIGHT DOUBLE
    - MAX_WEIGHT DOUBLE
    - INR DOUBLE
    - USD DOUBLE

    A better choice might be to replace the INR and USD columns with a single RATE column in a native currency and then convert to the desired currency.

    ** How you use/interface the table is left as an exercise.
     
    tandac, Dec 10, 2006 IP
  4. pushkar

    pushkar Peon

    Messages:
    125
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Hi tandac.
    Thanx for reply.
    I have design table successfully.
    But now i have a problem with APS.Its running fine but i have to write same thing so many times.Can u help me in ASP coding please???
     
    pushkar, Dec 10, 2006 IP
  5. kashem

    kashem Banned

    Messages:
    1,250
    Likes Received:
    76
    Best Answers:
    0
    Trophy Points:
    0
    #5

    You better post your specific problem here , then it will be easier to help you
     
    kashem, Dec 11, 2006 IP
  6. pushkar

    pushkar Peon

    Messages:
    125
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #6
    It is posted in ASP section.Just see it.
     
    pushkar, Dec 11, 2006 IP