Read data from two ref tables

[aminsaleh]

Hi, In my seller main form I have a customer field, it can add new customer or search for old customers here.

The customers table is a different table, can I make two tables for customers

table 1

table 2

and allow the above customer field in the order form to search and read data from the two tables. 

[TeeSee1]

You can combine lists from two tables to make a suggested values list. However, you cannot make the column a reference column any more and I assume that would break you app.

What is your reason for having two tables for customers? If you provide your intentions/requirements rather than solution ideas, you might get more suitable proposals from the community.

[aminsaleh]

Thank you for your help

Because appsheet google sheet is limited to about 100k .. I thought if in case I reach the 100k what to do

[TeeSee1 · Accepted solution]

If you are on an Enterprise license then Data Partitioning maybe your answer besides migrating to a more robust DBMS. I am only on a free plan and no experience on this myself. Maybe other members have better suggestions.

https://support.google.com/appsheet/answer/10105383?sjid=8985876769063475868-AP

[aminsaleh]

@TeeSee1  Thank you very much