ARS 7.5 P7
I have a form (formA) that sets a field on "Get Entry". This works
great when looking at records or running reports on FormA, even if the
field is display only.
Is there any reason why this filter wouldn't execute from another form
(FormB) performing a Set Fields operation of its own and using FormA as
its data source? Checking Filter logs, the GET event doesn't get
triggered for FormA when FormB is doing its Set Fields operation, so I
don't think this is a phasing or execution order problem. I cannot find
in the documentation whether this is expected behavior.
A little background, I want to pull in one piece of Customer data from
an external DB (cell phone #) but make sure that it is fresh whenever
it is displayed. So, I have a display only field on FormA that is set on
Get Entry using a SQL command data source. This works great when
viewing FormA. Now I want to make that visible on FormB. I can't. I
could setup the same DB Set Fields call on FormB, but I would need the
same key fields on that form to do the same SQL command. I could also
bring in the external DB as a view form and join that to FormA and then
go from there, but it seems more complex than it needs to be for just
this one piece of data.
Any ideas?
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
