create sql view windowsview as; SELECT windows.iID, cWindowLetter,; nQuantity, nWidth, nHeight,; nCostPerSqFt, nPrice, lNameplate,; lProtectiveCovering, lLightbox, lFrames,; lFinalMeasurement, ; lCircular,; CodesStyle.cValue as cWindowStyle, ; CodesTop.cValue as cWindowTop ; FROM windows ; INNER JOIN codes as CodesStyle; ON windows.iStyle = CodesStyle.iID; INNER JOIN codes as CodesTop; ON windows.iTopShape = CodesTop.iID ; WHERE windows.iProject = ?Projects.iID ; order by cWindowLetter>I have all my system codes in one table. I also have city, county, and state codes in their own tables. Am I setting myself up for major headaches with this? I have a patient table which contains the home address along with multiple system codes for marital status, race, sex, etc. This table is related to an Emergency Dept. visit table with its multiple system codes. The Visit table is related to an Injury table, which has system codes and an address for where the injury took place, and to an EMS table that has the city in which the Emergency Medical Service is located, etc.