I have two databases:
+ lots of other fields
+lots of other fields
I want to populate the field sessions:FullAddressSessions using data in the field clients:FullAddress on three occasions: when a new record is added in the sessions database, when an existing record is edited in the sessions database, and when some forms in the sessions database are opened.
The lookup produced by the Relational Workshop is:
so far so good.
But now I’m stuck. I do not know what to do with this lookup. Where does it go? Is it code to be connected with a field? Or is it a formula to be connected with a field? Is it a ‘form event procedure’? Or a different kind of procedure? I’m pretty sure it needs to be put into a variable before anything else - but I am unsure of the syntax for that as well,
Any help would be appreciated.