Drop Down Lists/ Combo Boxes

[Tallboy]

Hi Guys,

Am looking for a bit of advise I am seasoned MS Access Developer and love its simplicity and convenience particularly its Combo boxes.

I don't enter the data in the property field of the combo box but instead tie it to a small table and use its fields.

But I am moving to SQL Server and woudl liek to know how you tie a Combo box to a small table on a SQL Server.

All help appreciated


Regards

 

[bparkinson]

Assuming you are storing the foreign key from the lookup table, and your SQL Server tables are linked, it's no different that doing the same thing with local tables. Set control source, row source, row source type, and bound column properties, either manually or throught the control wizard.

 

[Tallboy]

Hi,

That makes sense alright, but is there any performance issues with linking?

Can you base a form on a linked swl server table?

See my next post.

Thnaks again

 

[bparkinson]

There can be performance issues, but not directly because of linking. My SQL Server is half a continent away, but the performance is fine. My developers are on a different continent, as are my users, and performance is fine. Performance can be impacted by network/internet speed.

All that aside, since you can get asynchronous processing, and do so much more in the back end, performance can be a lot better for many types of operations if you use stored procedurs as much as possible.

 

[Tallboy]

Hi Guys got it working thanks for the help !