Lookup Tables

[shankel]

Hello,
I was using an Access Data Project for SQL development and a front end. Now, I am ditching Access and creating an ASP.NET with VB.NET front end. I was using lookup tables with Access. How do I recreate the lookup associations now? Do I do it in SQL Server BackEnd or through .NET front end? When I look at the Main table outside of Access it only shows IDs, not associated data.
Thanks,
shankel

 

[wsmall73]

I would do this in the back-end of SQL using Stored Procedures to join your main tables and your lookup tables to return your desired result set. This would allow greater flexibility if you need to change some criteria on the flow (sort of acting like a middle-tier). Hope this helps.