I have a form based on a Charity List table and one of the fields in the table is NTEE_CODE1. There is another table that has all the NTEE codes with a description. I would like the description to display on the form. Below is the SQL that
was generated using query design. How do i connect the SQL with the field in the form so the description is displayed?
SELECT [NTEE CODES].DESCRIPTION
FROM [NTEE CODES] INNER JOIN [Charity List] ON [NTEE CODES].NTEE_CODE = [Charity List].NTEE_CODE1
WHERE (([Charity List].[NTEE_CODE1]=[NTEE CODES].[NTEE_CODE]));