[Appsheet] Can't make ref without list of answer

[quentinderavign]

Dear All,

I have this app with 2 tables Agent and Visits and I'm trying to create a ref beetween the 2 tabs.

The key colomn to be used in both table is the Telephone  of the agent.

So when i put the colomn Telephone in table "Visit" as a ref for the source table "agent", it works, i have a lynk between the 2 tables.

But the issue is when i create a new entry in visit, i have to choose the telephone in a list of value where i would like to be able to put whatever entry i want :

And if i clic on New, it opens a new entry for Agent...

PS : the key colomn is horodator.

Thanks for your help,

Quentin

[Joseph_Seddik]

So what is your question please? I'm not sure I fully understand your problem.

Also, would you please clarify what is the key column of the Agents table? In the beginning indicated it is the Phone number, then you said it is "horodator". 

I think it will be helpful to post screenshots of your tables in the app. Thank you.

[quentinderavign]

Hello Joseph, and thanks for the feedback.

I said a mistake, the key column for the 2 tables (Agent and visit) is the horodator. 

What can i do ?

Thanks

[Joseph_Seddik]

Merci Quentin,

Would you please also post screenshots for the Visits table? (better quality please 🙏)

And tell me what do you want to achieve. Thanks.