Alpha Video Training
Results 1 to 3 of 3

Thread: Summary on form of browse items.

  1. #1
    Member
    Real Name
    Rodney Efird
    Join Date
    Apr 2000
    Posts
    137

    Default Summary on form of browse items.

    Hello,
    I am working on an app that has detail items in the browse section of the form in a manner such as an invoice.

    I may have the same item used in two different areas of the product but I need to list them individualy.

    I would like to be able to have a section on the form that will take any duplicate entries on the same record and consolidate them so as to provide a better view of the items used in the costing form.

    As an example. I may have an item such as id 1 and this item may be used in two different areas of the unit. I need to list each occurance but would like a subtotal as well. Item 1 is listed 2 times each time using 3 pieces of item 1. This gives 6 total pieces and I need to be able to show this information as well as the detail of uisng item 1 in two different sections of the unit.

    Thanks

    Rodney

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default RE: Summary on form of browse items.

    You can define calculated fields for browses. Look at the dbsum() and tablesum() functions with an eye toward showing the total number of items as a column in your browse.

    You could also use these functions in a calculated field on your form.

    Stan

  3. #3
    Member
    Real Name
    Rodney Efird
    Join Date
    Apr 2000
    Posts
    137

    Default RE: Summary on form of browse items.

    Thanks Stan

Similar Threads

  1. browse mode- delete drop down list items
    By Larry Ternowski in forum Archived Wishlist
    Replies: 2
    Last Post: 05-10-2005, 04:43 PM
  2. Phantom Browse Items
    By BillCampbell in forum Alpha Five Version 6
    Replies: 0
    Last Post: 07-26-2004, 08:02 AM
  3. Bulleted Items in Form Letter
    By cboullear in forum Alpha Five Version 5
    Replies: 1
    Last Post: 06-25-2003, 03:03 PM
  4. ITEMS NOT SEEN IN BROWSE MODE
    By JAMES GRIFFIN in forum Alpha Five Version 4
    Replies: 4
    Last Post: 08-21-2001, 08:24 AM
  5. items disappearing from browse
    By Jeff Snyder in forum Alpha Five Version 4
    Replies: 5
    Last Post: 11-03-2000, 10:36 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
  •