Is it possible to get an Advanced Search Select field to see the User table?

I'm trying to pick up a field from the user table to automatically populate a field onto my custom entity when selected.

Very easy to do in an Advanced Search Select by setting in the 'Linked field' but not possible on a User Select!!

Is there any way I can get the lookup on 'Search Entity' to include the user table?

Thanks

  • 0

    Hi Roger

    For application security reasons we try very hard to stop the User table being treated like any other table.    Rather trying to force the User table to behave in a way Sage doesn't want it to in the UI, you could use a table level script to automatically assign the value as the record is saved.