Embedded browse is displaying same record multiple times

[acceptthis]

I have a form with an embedded browse based on a set like this:

Members
          |
           ======Transactions

What's happening is when I filter the browse, I end up getting multiple displays of the same record. See my picture.
If I take off the filter, things display fine again.
I mostly need the transactions to be displayed in the date order, so I placed an order expression on the set structure, and that works when I enter new records, but as soon as I place a filter on the transaction table, it displays funny.
The strange thing is, if I select to order of the transaction date in DESCENDING order, I have no problem. If I pick ASCENDING order, I have problems again.

Any Ideas? Is it clear as mud?

[acceptthis]

I've attached the database for anyone who wants to see what's happening.
A guarrenteed way to produce the problem is
1. Open the "Member with Transactions" Form.
2. Place focus on the "Trans. Date" field on the browse.
3. Press the Ascending Sort button on top menu.
4. Press the Decending Sort button and it sorts fine.

Another strange thing-- When you mouse click the page down part of the scroll bar, it won't go past the duplicated record. If you select the "one record at a time" button, It moves on to the other records, but until you do that, you can press the page down forever.

One last thing I've noticed is duplication always occurs on the second record.

[Tom Cone Jr]

Brad,

I took a look. Using the default form for your set I cannot cause the error you're seeing to occur. In your custom form you are applying several different filters at the same time. Parent records are included only if there are matching child table records. The set linkage definition sorts the transaction table records in ascending order based on the transaction date. Then you click the quick sort buttons to add another filter layer on top of the previous. Your browse also is trying to display 3 separate calc field columns that must be computed and recomputed for each row in the child table. These calcs have to be re-run each time you change the sort order using quick sort tools because one of the calc fields includes running totals for each line in the browse. I saw the behavior you report (in case you're seeking confirmation), but I think this may be a situation where the calc fields (especially the one using the report function run_total() ) is triggering the fault. Frankly, I think Alpha is repainting the browse before all the required calculations are completed. If you delete all the calc field columns and then delete the calc fields definitions the browse behaves correctly. In short, I think you've designed something here that Alpha Five can't handle. In part this may be because the running total function was designed for report layouts, not forms. I'll continue watching this thread in case others have more hopeful ideas for you.

-- tom

[acceptthis]

Tom,
Thanks for finding the cause of my problem.
I removed the calc->rtotal from the browse like you suggested

calc fields (especially the one using the report function run_total() ) is triggering the fault.

and no more problems.
I don't really need calc->rtotal, it just gives the browse more of an "account register" feel to it.
It actually doesn't work right anyway when there's a filter on the browse because it's only running the total for the few records that are filtered. That doesn't match the balance anyway.
Maybe, if there's a way to blank out the calculation of rtotal when the child table is filtered, and it only shows up when the full scope of transactions are displayed?
I don't know if that's worth the trouble for just "browse eye candy".
I guess I could just put buttons for printing reports if seeing the running total is important, because it works fine in reports.
Thanks again, and if there are any other ideas out there, let me know.

[first5.0]

acceptthis -
how do you create a filter for a browse?

[acceptthis]

filtering an embedded browse

I don't know if this is what you're after, but I think it is. If you understand xbasic, I was pointed to this code to solve the problem:

rec = parentform:tables:prospect.recno()  	'get record number of current customer
				  	'will use to return to same customer 
				   	'after running query that would otherwise
				   	'shift focus to first Customer in table

' in this example, I'm filtering my TODO_TYPE field by "timeless"								
parentform:tables:prospect.filter_expression = "TODO_TYPE=\"Timeless\""  'define filter expression
                                               'fieldname is all that's needed.  Notice the quote marks.
parentform:Tables:prospect.query.order = "SCH_DATE"                                            
parentform:tables:prospect.query() 		'run query against the Tasks table
                                		    'this uses the filter expression, previously defined
xbasic_wait_for_idle()           		'pause script while query completes running
parentform:tables:prospect.fetch_goto(rec)  'shift focus to the Customer record that
											'had focus before query ran
parentform.resynch()  					'resynch the form
parentform:prospect.fetch_first()		'move to top row in the browse

I also found information on this in the documentation, but I don't know how to find it again. I just copied and pasted it from one of my scripts.

[Stan Mathews]

search?

I also found information on this in the documentation, but I don't know how to find it again.

Open the webhelp, type something definitive in the words to search for box (I used fetch_goto(rec)).

Immediately was taken to Querying and Sorting Child Tables on a Form

[first5.0]

Thanks for the help, guys. So there is no 'genie' that can filter a browse? You would think that functionality would be an obvious feature to have within the Script Actions to complete without having to use code.

I actually had that page open in the help file when you posted your reply. I'm trying to filter a browse based upon a combobox value. I'm not a programmer or DB person so this last piece of my project is taking some time to complete....

I'll try modifying that code to use a combobox value.

fyi - here is my current database - http://www.macwellness.net/data/db.zip

[Colin Roberts]

Bryan
For Filter read Query
Try using the Query Genie - accisible from the Query Menu
Colin

[first5.0]

Colin -
Using that method will cause the Query Genie to open when the user clicks on a different Member, correct?

I want the user to be able to pick a member from a list and have the browse update automatically. (The browse shows all Referrals that are linked to that member.)

[Tom Cone Jr]

Bryan,

Not clear on your context.

If your form is based on a one to many set, the embedded browse for linked child table records will show all the linked records for the current parent table record. If you navigate to the next parent table record the embedded browse will automatically filter the child table to show only those records which are linked to the new parent.

If you want to limit the range of child table records being displayed for each parent record you simply need to define a filter for the child table. This is easily done using the properties of the form. Open the form in design mode, Choose Form menu, then Properties. Then click the Filter/Order tab and choose your child table. Very simple. A genie will help you build the filter expression if you wish.

-- tom

[first5.0]

Sorry for the confusion. I'm not sure how to use AlphaFive correctly so I don't know how to convey my problem using the correct terminology.

I have a member table which holds member info and a referral table which has all referrals (a referral is when an employee refers a member to a program). I created a set based on the referral table.

I'm now thinking that I need to make a set based upon the Member table which links to the referral table.

That could be my whole problem....

Yeah, that was it.

I feel like an idiot. I made a simple task turn into a nightmare. Thanks for your help guys! Sorry for being a complete noob!