Assign Value to a field in a child table

[johngtatp]

This should be easy but I am a newb and I have been frustrated for quite a while.

I have a set. In the child browse I have a logical field called select. I just would like to have a button on the form for "Select All" "Select None". This would make all the logical child records either .t. or .f.

ALSO

Similar but slightly different. I would like to have a button that would prompt for a date and change a date field in only the child records where select is =.t. and recalc the field rules.

I would really appreciate help on this. This should be simple but I am not seeing the forest through the trees.

[MikeC]

Re: Assign Value to a field in a child table

John,

I have done this by running a saved update operation from a button--one for tagging (true) and another for untagging (false) logical fields.

On your second question my approach would be similar---most likely setting the selected date to a variable and then running a saved update operation for records that match your query...setting the date fields equal to the variable.


Mike

[johngtatp]

Re: Assign Value to a field in a child table

That worked, thanks. I knew there was an easy way. Thanks again.

[Tom Cone Jr]

Re: Assign Value to a field in a child table

John,

Another approach would involve getting a pointer to the open child table and then fetching through the linked records, updating them one by one if the filter criteria are satisfied. This would eliminate the need to run a saved update operation against another instance of the same table.

--tom

[smrogers]

Re: Assign Value to a field in a child table

Tom,

Would you mind expanding on your previous message, and possibly giving a somewhat working example/explanation? For some of us less experienced,

...getting a pointer to the open child table and then fetching through the linked records, updating them one by one if the filter criteria are satisfied...

sounds daunting... thanks!

[Mike Wilson]

Re: Assign Value to a field in a child table

Shawn,
The attached is an example of what you requested, and I believe what Tom was describing. The database is a 1:M Parent:Child, and should open to a form with parent and child. The Parent contains states (regions). The child contains multiple entries for each state. The red button has the script example. It sequences through two text dialog boxes, each having a default entry. In the first, just add a number at the end to complete it (make it wild to see the change), and in the second, it will default to "A", so just press the OK button. The second In-Line Xbasic Action Script in the button On-Push event directs the action of coursing throught the records of the child table and change each child record as Tom described.

Hope this helps.

[Tom Cone Jr]

Re: Assign Value to a field in a child table

Here's another example. Unzip the attachment to an empty folder. Open Form1. There are two buttons. These illustrate another approach to updating field values in the child table records linked to the current parent table record.

Mike Wilson uses a similar approach but employs a query to limit the range of child table records to be processed. I step through all the child table records evaluating each as I go, without running a query.

John, if you need to process all child table records (not just those linked to the current parent table record), then MikeC's saved update operation is probably a better approach.

-- tom

[Mike Wilson]

Re: Assign Value to a field in a child table

Tom,
Nice example. It was a learning experience for me in seeing that if t.adopted is all you need and the equation = .T. is implicit for the logical field.

For completeness sake, RED is not showing in the listbox because it resides in the code position for the default_number.

[COLOR="Blue"]'user selects color from list[/COLOR]
New_color = ui_get_list("Pick new color",[COLOR="Red"]1[/COLOR],"Red","Blue","Green","Orange", "Orange and Blue","Go Gators")
if New_color = "" then  [COLOR="Blue"]'user chose cancel[/COLOR]
	end 
end if

[Tom Cone Jr]

Re: Assign Value to a field in a child table

Thanks, Mike.

-- tom

[smrogers]

Re: Assign Value to a field in a child table

Thanks for the examples Tom and Mike... once I solve a very frustrating problem with Alpha running on Vista (so far no one at Alpha has responded to my desperate plea for help), I'll take a look at your postings...