Hi team, i create a table "listas" with two ...

references
(Johny Freitas) #1

Hi team,

i create a table “listas” with two columns

“nomes” and “nomes2”.

in my

primary table “Maintenance” i have the same two columns nomes and nomes2 and i want to ref them to table listas to get their values.

but when i do it, i only get the refs from column nomes in table listas.

and i need to get

nomes from column nomes and nomes2 from column nomes 2.

how can i do it?

(Reza Raoofi) #2

Each Ref column should refer to a separate table; I believe the issue here is that both your nomes and nomes2 columns are referring to the same table.

I recommend reading this page: http://help.appsheet.com/data/references/references-between-tables