Another screen Shot when selected. I wish to clear all
The field you are clearing does not appear to be a global field. Thus you need to clear this field for each record shown in the portal.
You can either loop through your portal rows with Go to portal row or you can freeze the window, pull up this same set of records on a layout based on the portal table and use a single Replace Field Contents step to clear the field.
To pull up the records shown in a filtered portal can be a bit of a challenge, you'd start with Go To Related Records, then use constrain found set to filter the found set down to those that meet the current values specified in your filter expression.
Why isn't it a global field? I have set up as global Text field and have the relation ship as gS_sort:: OrderEntry X Sort::products4select
doesn't clear the global field gS_Sort, it clears a field named Sort--the naming convention and the way it appears in your screen shots (assuming it is the radio button listed on every portal row) suggested to me that it is not a global field. I could easily be wrong, I'm just going by appearances here.
Im trying to use like my other global fields difference being the button instead of text this is where I got into the problem. So yes I have a global field gS_Sort from my parent table to a field called "Sort" in my child. I wish to selct items I need to create a report and then when finished clear the buttons.
Yes, but the set field step that clears a field that you original posted does not clear the gS_Sort field. if gS_Sort field is a global field and your set field step were:
Set Field [ Order_Entry::gS_Sort ; "" ]
Then that single script step should clear the gS_Sort field.
Maybe Im missing something here. The Order Entry Table that uses all of the Global Fields be it name, Item size etc are all gS_ they all share a code or number in common. I just ran a test and the field is an edit box instead of a button and enter "Yes" the gS_Sort::Order Entry script does clear. however as a radio button it does not??? somehow it being a radio button is the difference. is there an other value I should be clearing
Please read my previous posts very carefully. Going from what you have posted, your script clears the wrong field. It does not clear the gS_sort field. It clears a field of a different name.
After much experimenting your suggestion of "freeze the window, pull up this same set of records on a layout based on the portal table and use a single Replace Field Contents step to clear the field." is the correct one. While I have this assigned as a global field I realize the information isnt common to every record and when clearing the Global field will not do what I need.
Would you have an example file that uses the "Freeze window go to other layout function"
Thank you for the help.
The basic outline would be:
Go to Related records
Enter find mode
Specify find criteria to "filter" the records
Constrain found set
Replace Field contents
Go to layout [original layout]
Go to Related Records will pull up all related records so you would need the steps shown in blue to filter out those records currently excluded from the portal by your filter expression. You'd use a series of set field steps to specify criteria in different fields to reproduce the logic of your portal filter calculation.