Hi Folks
I have searched various locations for a solution to this and have had noluck so far, any help of course apprecited.
The basic issue is as per subject line, some detail below.
I am trying to setup a simple dataset for a group I work with. They need to conduct a survey of supervisors asking for a rating.
If I create a flat table or simple query (based on one table) and use it as a source to use the "create email" wizard, it works well, sending only those parts of into to the person whose email is related to that line of data. Fantastic, really.
However if I want to make a more structured database and prevent storing loads of unnecessary repetative data (ie email address for supervisor and manager and site manager for every single person), the email that is sent contains one set of fields, all data blank. (using HTML and infopath)
Ahhh I hear you thinking I have forgotten something in my query. well, the query works as required and shows correct data (including the email address from the alternate table) AND I used a table from Northwind database to confirm.
I can only assume others have had this problem, is there a solution to this specific issue or do I jsut have to keep making flat tables (or Create a table from a query, send that data, get the response, place it back in the new table then update the original data from the created flat table.. ARGH).
PLEASE dont make me have to learn to code for Access
Thanks in advance
David