I would like to use an enricher to set a FK on my entity (lets call it MAIN).
my MAIN entity has FK's to tables A and B.
the FID for entity B is an attribute on a record in table A
essentially Id like to do this in an enricher:
for entity attribute "FID_TableA"
set the value to the ID where TableA.attributeA = FID_TableB
the FID for TableB is a value that the user can set in the form.
I know I can create and call a database function in the enricher to give me the FID, but wondering if perhaps I could somehow do this in the enricher itself.
Michael BARTLEY
Hi there,
I would like to use an enricher to set a FK on my entity (lets call it MAIN).
my MAIN entity has FK's to tables A and B.
the FID for entity B is an attribute on a record in table A
essentially Id like to do this in an enricher:
for entity attribute "FID_TableA"
set the value to the ID where TableA.attributeA = FID_TableB
the FID for TableB is a value that the user can set in the form.
I know I can create and call a database function in the enricher to give me the FID, but wondering if perhaps I could somehow do this in the enricher itself.
thank you