1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Please Help Me

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

0
  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:
      268
    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