Results 1 to 5 of 5

Thread: Format help

  1. #1
    Join Date
    Sep 2008
    Posts
    5

    Unanswered: Format help

    Hello,

    I need some help to define a format for my Order Number field in the table.

    I have few site names and they all have unique names. Now i like my order numbers to start with the first 3 letter of each site name and i like to be able to select them!

    How is this possible? Can anyone help?

    Thanks,
    Yizi

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    how do you know what order belongs to what site
    how do you encode the site prefix
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Sep 2008
    Posts
    5
    Well its a purchase order, i like it as a drop down so i can selete and the rest of the code i type in or it generates automatically (i perfer automatically)

    Something like:
    (DROPDOWN-AUTOGENERATED-FILED)

    DROPDOWN - is the list of developments
    AUTOGENERATED - is the 3 digit auto generated number
    FIELD - is the blank field so we can enter a 3 digit number ourselves

    Need masters help really
    Thanks,
    Yizi

  4. #4
    Join Date
    Sep 2008
    Posts
    5
    Anyone can help?

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    so do you have individual series purchase orders for each site, or do you have a single purchase order system with a code to identify which site placed the order

    eg
    ABC00001, ABC00002,ABC00003, BCD00001,CDE00001
    or
    ABC00001, ABC00002,ABC00003, BCD00004,CDE00005

    im not sure where you problem lies, or even what it is
    is the problem how you store the data
    ho you report it?
    how you identify it?
    how your users type in the data?

    can we see your table design
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •