A single reference field that displays records from two different tables

[beycos]

Hello Everyone, 

in ServiceNow, is it possible to create a single reference field that displays records from two different tables? I want one reference field that shows both departments and groups as selectable options. Is there any supported way to merge multiple tables into one reference source?

Any guidance would be appreciated.

[GlideFather]

Hi @beycos,

not possible. A reference field is associated with a table, so unless that table is not extending that it is not possible.

What is possible - field referencing to Task - there are selectable records from Task, Incident, RITMs, Problems, Interactions, .... because they are all extending the Task.

But if you want one field to reference Location and Department (two different tables), then it is not possible.

[Dr Atul G- LNG]

No mate, not possible. You can get results by combining two tables as database view but not used in single reference.

[Ankur Bawiskar]

@beycos 

what you are looking for is not feasible

But what's your actual business requirement?

If you let us know we might help better

[Mark Manders]

The only way to do this is to create a custom table (mind your license agreement!!) and add both tables as reference field on that, including a display field that is a combination of both. But you can't reference two tables in one field.