What Am I Doing Wrong?

[markbwillard]

I am trying to figure something out but failed.

I have a form and have a browse on the form with several fields.

Two thing:

1)
I am trying to pass filed value to filter the browser. it works fine BUT it puts me to first parent record.

Say I am on parent record id no. 2. while I am on that i am trying to filter data and as soon as I click filter button it puts me back to record number 1.

What is really doing on and how do I fix this? If I am on record #2 I would like to stay on 2 and use the fileds to filter data out.

2)
Also, when I am using the filter I would like to show a messgge if the value does not exit in the browse table and don't do anything. How would i accomplish this.

My project is attached.

Also here is the code I am using to filter the

datafilter="(mainfilter = "+quote(mainfilter.value)+")"
topparent:tables:producttable.filter_expression =  datafilter
topparent:tables:producttable.query()
end

[johnkoh]

Re: What Am I Doing Wrong?

Mark,

Searching the child records from one to many set's form has the problem and see Learning Alpha Five. They have a few article about the query on child tables.

The Child record searching is not simple as you think and maybe, you have to Re-design of your structure ...

[markbwillard]

Re: What Am I Doing Wrong?

Any references?

[markbwillard]

Re: What Am I Doing Wrong?

It works in term of filtering but the main problem is the parent record goes to the my 1st record.

[johnkoh]

Re: What Am I Doing Wrong?

Mark,

I think your code is fine with in one table and but
I think after found the records from child table, A5 is forced to go the first record. I could be wrong and read the articles from Learn Alpha...

[martinwcole]

Re: What Am I Doing Wrong?

I didn't look at your code, but if you are using xbasic, should be a snap - I have had this issue for years.

define a global variable in the auto exec

dim global rnum as n
(rnum for record_number)

then in the code that runs the query say

dim global rnum as n
t=table.current(1) 'the parent
rnum=t.recno()

'run the query

then
t=table.current()
if t.recno() <> var->rnum
parentform.index_set("")
parentform.find(var->rnum)

[markbwillard]

Re: What Am I Doing Wrong?

Hi Marrin:

Can you give me a sample project? I am not familiar with with instruction you provided, and x-basic.

Thanks.

[martinwcole]

Re: What Am I Doing Wrong?

If you have logmein or similar, send me a link to get on your computer, and I'll see if I can help you fix it - it's too time consuming to write an app.

[markbwillard]

Re: What Am I Doing Wrong?

Sent you my contact number to call or can I call you?

[markbwillard]

Re: What Am I Doing Wrong?

Hi Martin:

One new issue. The filter works great for existing parent record but the filter shows the data for few seconds and then disappears after that. This only happens when I am creating a new record.

Any help would be great! Screencast is attached.

thanks.
Mark

[Ray in Capetown]

Re: What Am I Doing Wrong?

Mark, your questions are valid.
To be of use in the future please start a new thread for each problem and title it appropriately so the help given will serve others with similar problems.
As well as attract more relevant help for the topic.
Like "Filtering child records shows then disappears creating a new record"

Then explain what is disappearing
"..filter shows the data for few seconds and then disappears "

[johnkoh]

Re: What Am I Doing Wrong?

Mark,

The filter works great for existing parent record but the filter shows the data for few seconds and then disappears after that

That is right and It should be that way. I assume that you want to do this ... filter with group from product table and see it in a form. or ....