Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
When inserting or editing rows ("Edit Top 200 Rows") for a table with a FK constraint, can the editor be configured to select the foreign row, rather than me having to look up the FK?
No. You're referring to SQL Server Management Studio, presumably, and that behaviour doesn't exist there. There are other applications you can use that will leverage FKs in that way though.
Required, but never shown