SQL Server List Box in one field/ table referencing items located in another field/ table?

Question

How does one create a list box in a field (Table A) with items referencing a field in table B so that the user updating the table is able to select from the items? I'm hoping there is a non C# writing method (just using the SQL Server features). What is the most simple solution? Very much appreciate your help and guidance! Thanks- Andrew

Answer 1

You can't do that with only SQL Server features. SQL Server is not a UI tool, and it does not have a UI itself. That does not mean that you need to use C#; there are plenty of other environments: Java, Delphi, Access and probably a few more.

Answer 2

Hi Andrew Wolf

You can use a foreign key relationship to create a list box in a field (Table A) referencing items from another field (Field B) in another table.

add these

Table A: Add a field (ForeignKeyReference) for the foreign key.

Table B: Has a field (ForeignKeyField) containing reference items.

Create Foreign Key Relationship, Link Table A.ForeignKeyReference to Table B.ForeignKeyField. for UI Dropdown In your UI, use a dropdown or combo box for ForeignKeyReference. now populate the dropdown dynamically from distinct values in Table B.ForeignKeyField.

SELECT DISTINCT ForeignKeyField
FROM TableB;

If this helps kindly accept the answer thanks much.