How to reference field with multiple tables

[Bharat23]

Is there a way to configure a reference field to read from two different tables? Currently we have a reference field which reads from Table1 now we are splitting the data in Table1 among two tables Table1 and Table2 and it will be really helpful if we can use the same reference field for both the tables.

Any suggestions?

Thank you...

[ahaz86]

I dont think you will be able to reference 2 tables in one field. if you need the data on 2 separate tables, you will need to have a third table that has the values from the other 2.

Someone can correct me if I am mistaken on this

[ahmeid]

Hi,

You can use a document ID field in combination with a table field.

For an example look at the sys_email table and the fields: target_table and instance.

The Document ID field still stores a sys_id, the same way as a reference field, but if you make the field dependant on the table field, you can then dynamically select where it references.

Ahmed

[Nestor2]

That actually solves the issue, thanks!

[Pato_Herrera]

how?