Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 foreign key as drop down menu

Author  Topic 

spinoza
Starting Member

49 Posts

Posted - 2006-04-05 : 02:07:51
hi all,

I have a table called suppliers where i type my suppliers details.
I have also a table called supp_corellation in which i have the proffesion of my suppliers.

there is one column in the table of suppliers which it takes data from the table supp_corellation . Is it possible to choose the values from a list instead of typing in my table (lets say drop down list)???

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-04-05 : 02:20:19
Nopes i dont think you can do that using any of the microsoft client tools.. may be 3rd party tools would have these features..

If Debugging is the process of removing Bugs then i Guess programming should be process of Adding them.
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-04-05 : 02:42:01
No. Use joins with where condition that filters data

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

spinoza
Starting Member

49 Posts

Posted - 2006-04-05 : 04:42:53
thank you very much
Go to Top of Page
   

- Advertisement -