Filter an embeded Browse ?

[Daniel Weiss]

In a one to many set on a from with a embed browse (for the child table). How can I filter the browse to show only the records that match a field value on the form, which is not the set�s linking field?
Thanks
Dan

[Stan Mathews]

RE: Filter an embeded Browse ?

I think this applies.....

Msg ID: 21618
Subject: RE: Filter Parent With Child
Author: Tom Cone Jr
Date: 05-31-2000 17:45
File:

One way to do this is to define a query "operation".

Using the invoice database that shipped as a sample by Alpha Software, I chose the Vendors Set. This uses a 1:Many link between vendor table and product table.

I defined a new operation to be based on this set, to query records.

I specified vendor_id as the field (from the parent table, Vendor). And, exist(vendor_id,"Products.dbf","vendor") as the condition.

When the new operation is run, a query is performed against the set, and parent records are included only if they have a related child record.

This was verified by adding a new vendor to the vendor table, without adding any related product records in the product table. The new vendor is excluded from the query view created by the new operation.

Hope this helps.

-- tom cone

[Daniel Weiss]

RE: Filter an embeded Browse ?

Thanks Stain
But I�m actually trying to do the opposite.
For example; If the set�s Linking field could have child records of several customers types, and I want to filter the browse for the child�s table to show only the records of the current customer in the parent table
Thanks for Helping
Dan

[Daniel Weiss]

RE: Filter an embeded Browse ?

Still need a solution, I�m sure its probably very simple, I just cant figure it out,
Any Help Please!
Thanks
Dan

[Jake Vuckovic]

RE: Filter an embeded Browse ?

I think that flattenquery() can be used to achieve this. Check out xbasic manual, page 215.
This function allows you to filter on any combination of fields from both parent and child.
Jake

[Daniel Weiss]

RE: Filter an embeded Browse ?

Thanks Jake
As far as I understood, flattenquery() is only for filtering the parent table by fields from a child record. But I tried it anyway, and it only filters the parent
Thanks, I�m still out of luck
Dan

[whanigsberg]

RE: Filter an embeded Browse ?

Daniel:

This is just a guess.

Perhaps you could index the field (in the child table) and then use the exist() function in the browse's filter expression.

I haven't done this so I am curious to see if if it would work.

Bill

[Stan Mathews]

RE: Filter an embeded Browse ?

Dave,

Am I correct in thinking you want to show records for only the current parent record, say a customer, but there is nothing in the child table which ties a record to a customer? Maybe the child table is a set of transaction types with codes, linked to the parent based on the code, and you want to show all transaction types used for the current customer.

I'm just trying to understand your setup.

[whanigsberg]

RE: Filter an embeded Browse ?

Daniel,

Wait a sec. The form has order and filter expressions for the child table. You can reference the child fields in these expressions. Could you not put code on the form's on_fetch event to set the value of a global variable to the parent field value. Then you could use the variable in the filter expression. You might need to refresh the form.

Does this get you where you need to be?

Bill

[Daniel Weiss]

RE: Filter an embeded Browse ?

Thanks all for trying to help;

Stain , No the child table dose have a customer id field which ties a record to a customer

I think I figured it out, and as I said it very simple just overlooked it
This script is on the �onarrive browse event�

dim tbl as p
dim query.order as c
dim query.description as c
dim query.options as c
dim query.filter as c
tbl = table.current(2)
query.description="current customer"
query.order="invoice_no"
query.options="M"
query.filter= "Cust_id = '" + cust_id.text + "'"
tbl.query_create() ;tbl.close()
browse1.fetch_first()
Browse1:Pay_Now.Activate()

Its seems like it works fine , The tbl = table.current(2) filters the child table in the current form

Thanks again
Dan

[Daniel Weiss]

RE: Filter an embeded Browse ?

Bill
That wont work because cant reference a child table to filed from the parent tableand also it gets very complicated �on_fetch � on_save- on_enter" Etc


Dan

[Daniel Weiss]

RE: Filter an embeded Browse ?

Sorry
You need to remove the TBL.CLOSE() from the above script
Dan