Can anyone tell me the most efficient way to update a foundset for 1 or more columns?
With a fixed value this is easy and fast via databaseManager foundsetupdater.
What I have here is:
2 tables, connected to eachother via primary & foreign key
'foreigntable' has: column X
and I need to get the related value as fast as possible into a large foundset in the 'primarytable'
I could do this by iterating the foundset on a form, but this will be slow.
Is there any way to do this via the foundsetupdater as well, or to push a dataset back to the table (matching key of course)?
Maybe I just overlook possibilities, but I can't get it clear at the moment...