Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Custom Order (2000)

    We have a form based on tblSalesProgression which we would want the user to put a custom order.

    The table consists of:

    SalesProgID
    Solicitor
    Agent
    VendorName

    We want to be able to enter the details in any order so that we can re-organise it so that in the right process order. E.G eneter the details of each section of a house sale chain

    person a
    person b
    person c

    However C maybe buying from A and C maybe buying B's house so the order would be viewed as:

    B
    C
    A


    Any ideas?
    Best Regards,

    Luke

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Custom Order (2000)

    You could add a number field SortOrder in which the user can specify 1 for the record to be listed first, etc.

  3. #3
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Custom Order (2000)

    How would this be used in the form?
    Best Regards,

    Luke

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Custom Order (2000)

    By placing a text box bound to the new field on the form.

  5. #5
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Custom Order (2000)

    That is done, but how to get it to order the form by that number in the box?
    Best Regards,

    Luke

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Custom Order (2000)

    Create a query based on the table, sorted on the number field.
    Use the query as data source for the form.
    When the user has changed the numbers, the form must be requeried.

Posting Permissions

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