Alpha Video Training
Results 1 to 4 of 4

Thread: Child database sort order

  1. #1
    Member
    Real Name
    Philip Brides
    Join Date
    Jan 2006
    Posts
    5

    Default Child database sort order

    Using A5v1 I have created a form within a set that is linked by Lot_nbr to both the parent and child databases. In the child database I would like the sort order to be by the Lot_nbr then Grave_nbr. [1,2,3,4, etc]. The grave numbers seem to appear by record number. Can anyone come up with a solution?

    Thank you,

    Phil

  2. #2
    "Certified" Alphaholic
    Real Name
    Mike Christensen
    Join Date
    Nov 2005
    Location
    Michigan U.P.
    Posts
    5,937

    Default Re: Child database sort order

    Phil,
    I would think that using the form properties Filter/Order tab is the easiest way to do this (Right click on the form in design mode and choose Properties)---I don't have V1 however but would think this feature has been around for some time. From this area you can filter and/or Order whatever Table you want in the set.

    Mike

  3. #3
    Member
    Real Name
    Philip Brides
    Join Date
    Jan 2006
    Posts
    5

    Default Re: Child database sort order

    Mike,
    (Right click on the form in design mode and choose Properties)

    When I get to Form Properties there is not a Filter/Order tab.

    Phil

  4. #4
    "Certified" Alphaholic
    Real Name
    Mike Christensen
    Join Date
    Nov 2005
    Location
    Michigan U.P.
    Posts
    5,937

    Default Re: Child database sort order

    Phil,

    There must be quite a difference between V1 and V5 then and without knowing all the differences I would be hard pressed to be able to help you. If your version does not have form order/filter capabilities then I would suggest creating a query for the records and place your order equation in that.

    Hopefully someone who knows what the differences are in V1 compared with later versions will contribute.



    Mike

Similar Threads

  1. sort by Biblical order
    By Philip Ramstad in forum Alpha Four Versions 7 and 8
    Replies: 7
    Last Post: 06-05-2005, 01:13 PM
  2. sort order from newbie
    By Tony Moloney in forum Alpha Five Version 5
    Replies: 2
    Last Post: 07-16-2004, 06:32 PM
  3. Report sort order
    By Edward F. Schulz in forum Alpha Five Version 4
    Replies: 6
    Last Post: 11-09-2002, 01:16 PM
  4. Sort Order
    By Juli Carey in forum Alpha Five Version 4
    Replies: 7
    Last Post: 11-08-2001, 03:33 AM
  5. Letter Sort Order
    By John Oesterle in forum Alpha Five Version 4
    Replies: 0
    Last Post: 05-18-2000, 08:21 AM

Bookmarks

Posting Permissions

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