Alpha Video Training
Results 1 to 3 of 3

Thread: Auto incrementing in embedded browse

  1. #1
    Member
    Real Name
    Jeff Fried
    Join Date
    Aug 2000
    Posts
    589

    Default Auto incrementing in embedded browse

    Problem: a user adding a line item in an order is first taken to a field for line item number. I would like to see the next sequential line item number defaulted to. For example, if there are already two line items numbered 1 and 2, the user would see 3 when adding the next item, and be taken to the next field.

    I've seen solutions for auto incrementing where the housekeeping is done when saving the record but not when first entering a new child record. This was easy to set up in Alpha Four, but I never found a clean way in A5V5, and I haven't seen anything added on this subject in A5V6.

    Since this is such a fundamental need when entering invoices, orders, etc., I wonder if someone has found an elegant solution to this. I appreciate any help you can provide. Thanks.

    Jeff

  2. #2
    "Certified" Alphaholic
    Real Name
    William Hanigsberg
    Join Date
    Apr 2000
    Location
    Toronto, ON
    Posts
    4,018

    Default RE: Auto incrementing in embedded browse

    At learnalpha.com there is an article on numbering browse lines.

    Bill

  3. #3
    "Certified" Alphaholic
    Real Name
    Russ Boehle
    Join Date
    Mar 2000
    Location
    Connecticut
    Posts
    2,767

    Default RE: Auto incrementing in embedded browse

    Hi Jeff,
    What I do is put a calc field on the parent form which calcs the number of lines. When you add a line in a browse (or a form) you can use the value in the calc field + 1. If you want you can hide the calc field on the parent if there is no need for the user to see it.

    Russ

Similar Threads

  1. Embedded Browse
    By Lawrie in forum Alpha Five Version 7
    Replies: 1
    Last Post: 09-26-2005, 02:17 PM
  2. ::: Embedded Browse
    By Kevin Willis in forum Alpha Five Version 6
    Replies: 3
    Last Post: 02-27-2005, 10:00 PM
  3. auto incrementing not working
    By Jeff Fried in forum Alpha Five Version 5
    Replies: 29
    Last Post: 03-14-2004, 06:58 AM
  4. embedded browse
    By WillieLucas in forum Alpha Five Version 5
    Replies: 0
    Last Post: 06-12-2003, 01:08 PM
  5. Monthly Auto incrementing
    By Mark Iampietro in forum Alpha Five Version 4
    Replies: 2
    Last Post: 01-31-2003, 10:55 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
  •