johnf wrote: > On Wednesday 27 June 2007 07:44, Paul McNett wrote: >> johnf wrote: >>> Hi, >>> Is there a demo/example of using VirtualFields looking up a FK in a >>> normalized DB? >>> >>> Paul as I recall you created VirtualFields for this purpose - right? >> Not really... I usually limit VirtualFields to calculations or >> formatting of real fields. > OK thanks - I was attempting to get around the issue of NonUpDateFields > currently not working.
You *could* use VirtualFields to lookup a FK, but I don't think that would be a good idea performance-wise because you'd be running the lookup every time the field needed to get displayed (every update cycle). Although a good side-effect is you'd not need to trap for when the user changes the FK and now the description field needs to grab the values for that FK... -- pkm ~ http://paulmcnett.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/dabo-users/[EMAIL PROTECTED]
