Search results for query: *

thank you SO much PHV! that's exactly what I was looking for. Leslie - I didn't get to try yours but I will do that to and read up on Joins at that link you sent. Thanks again! I really appreciate the help :)

i will read up on lookup fields in tables and see if that helps...thanks :)

alright, not sure if this will help or not but here is the SQL for a query I have working. This one will display the recommendation along with both the Section and Category names. Now I just need to somehow get the SubCategory names in there... SELECT tbl_Recommendations.AuditID...

ok, sorry...this is my first time with forums, let me try to explain a little bit better... In my recommendations table i have 3 fields as my primary keys (DocumentID, RecOrder, RecOrderAlpha). I then have the following fields/datatypes in addition to a Recommendation field (Memo). 1) a...

There are 4 tables that I am working with for this query. Recommendation, Section, Category, and SubCategory. I have a form allowing the user to categorize recommendations by section, category, and subcategory using cascading combo boxes. The ID (either a number or letter) is then stored in...