Announcements
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 529 Most Valuable Professional
Haque 230
Kalathiya 217 Super User 2026 Season 1
