First of all, keep in mind that I am learning to use SQL 2000 and Visual InterDev 6 at the same time, while also learning to program in Visual Basic 6. I am not yet proficient with all of the terminology of this stuff, so I very well could be using the wrong terms here and there.
I’ve learned that storing data in SQL tables and building a font-end app to access those tables (doing lookup queries or whatever) is significantly different, obviously, from using Access and setting a table column’s data type to “Look-up Wizard.” I’m comfortable working in Enterprise Manager, building tables, using the QA to create Stored Procedures, etc. I guess the best thing to do is spell out an example so here goes.
I’ve got 3 tables: tbl_manufacturers, tbl_models, and tbl_computers. I’m trying to use logic and think ahead as to how I might want to sort and query my database, so some of what I’m doing might make sense to you and some of it might not. I’m always open for criticism and knowledge. The tbl_manufacturers table will consist of one an ID column and a Manufacturer column. The tbl_model table will consist of an ID column, a Model column, and a Manufacturer column. The tbl_computers table will consist of several columns storing information about the computers at my company, but the only relevant columns for this example are the ID, Model, and Manufacturer columns. So let’s pretend that the tbl_computers table only consists of these 3 columns.
What I’m doing is building ASP pages using InterDev that will be used to query the database, add, delete and edit records. I want to be able to have pages that allow someone to add a new record to the tbl_computers table, and disply the list from the tbl_manufacturers and tbl_models tables to provide them with a list from which they will choose the appropriate items when adding a new record to the tbl_computers table. Gotta run, I’ll finish this later. Thanks for your help.
