MS Access to SQL Server Migration

[MicahDB]

I'm fairly new to SQL Server, but I'm really wanting to learn the ins-and-outs.

I've got an Access database that I'd like to port to SQL, but the Access database functioning is predicated on the ability to populate a field with a List Box or a Combo Box with the source being a column in another table.

I imported my access tables into SQL Server, thinking that functionality would import translated as the SQL functionality, but it didn't. Just the table data was copied over.

How do I go about connecting a SQL db column to pull based on data from another sql db table. I'm not even sure what that's called? Column Lookup...something like that.

If someone could just point me in the right direction, that would be great.

Thanks,
Micah

 

[SQLSister]

Are you using the same Access front end or are you writing a new front end in something else?

Questions about posting. See faq183-874

 

[MicahDB]

Well, let me supply a little more data.

A former 'developer' (I use the term losely) wrote an access app that reports sales profit numbers for a reporting period.

The one good thing about it, is that there's a table structure (Area -> Region -> Territory -> ZipCode) that will take the billing account for every order and assign a Territory, Region and Area to the order based on it's ZipCode.

So to answer your question, I'd like to take that same structure and use it in my SQL db. I'm not really looking at frontend developement at this point more just a reporting db to use the same table structure. Make sense?

Thanks again,
Micah

 

[SQLSister]

There is no way to get list boxes and combo boxes in SQL Server. This is front end functionality. SQL Server is only a backend, not a front and backend like Access.

You can look up constraints in BOL to see how to restrict the data entry to a range of values.


Questions about posting. See faq183-874