Basic Lookup question

[frenchy]

Apologies in advance for this basic question.....

Can a table pull drop down choices from a separate lookup table?  It works fine from Datapages, but I can't seem to work it out for table to tables.

Thanks

[IamNatoyThatLovesYou]

Hi @frenchy, You cant have a dropdown lookup table in using a table, but if you want to get other fields from another table to your current table, you can just use a view instead.

You can this link for lookup tables and this for views

[Kurumi]

Hi @frenchy,

No need to apologize 

If you are referring to drop-down like choices in your table, you can see it if the certain fields have a relationship. You can check these links for reference.

https://howto.caspio.com/tables-and-views/relationships/database-relationships/
https://howto.caspio.com/tables-and-views/relationships/creating-and-managing-relationships/

I hope it helps!