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...

[erck]

Can you explain how? 

[Anurag Tripathi]

If table 1 and table 2 both extend the same table, then you can refer the parent table.

EG, task.number will hold INCXXXX and also CHGXXXX

[burmakranthi]

if the table names are server and database,what should i do

[Anurag Tripathi]

Can you elaborate on what you want to achieve?

[burmakranthi]

i want a reference field with 2 tables in it

the tables are server and database

and it shoulb be a multipick like macros