Hi,
I try to create a column that link to another table, there's no lookup format for me to choose.
How can I create a column as a foreign key linked to other table?
Thank you!
Hi @feiyechen,
The formats you see are based on the data type selected, which is single line of text in this case. You need to select Lookup in the Data Type drop down.
---Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.
Thank you for the reply, but I just have Plain text and Autonumber to choose
Once you've created the column, you can't change from a text to a Lookup, only to compatible text formats or data types such as Autonumer.
You will need to create a new column. Select Lookup as the data type.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 819 Most Valuable Professional
Michael E. Gernaey 308 Super User 2025 Season 2
MS.Ragavendar 222 Super User 2025 Season 2