Hi I wonder/hope someone can help me please?
I had a lot of help developing my db, infact it was set up step by step with interaction with me.
In a nutshell I have a list of all the materials we supply, a list of suppliers, and a list of substances the materials could/don't contain.
I can send them a letter if I do not have their email address, which attachs a List of the Substances and list of the materials they currently supply to us, and the database records the comm's onto a Comm's table.
If I do hold an email address for them, there is another button that compiles the emailable version as above.
If however, I do not hear from them with a 90 day time, I can send them a chaser email or letter, but it is not attaching their Material List, its attaching a Material List, but a different supplier it but it does not match their supplier id, if that makes sense.
I have tried to look into the details in the build view, but I am not sure if I can identify where it is pulling the supplier ID from.
I am not sure how to rectify it as I can't see where it is pulling the supplier ID from, it is adding the comms letter(or email) to the correct supplier id. I thought I would be able to see OK it should be pulling the supplier ID from the form, I can't find where its getting the wrong supplier id from.
I hope somebody can help me please?
Thank you in advance
Clair
I had a lot of help developing my db, infact it was set up step by step with interaction with me.
In a nutshell I have a list of all the materials we supply, a list of suppliers, and a list of substances the materials could/don't contain.
I can send them a letter if I do not have their email address, which attachs a List of the Substances and list of the materials they currently supply to us, and the database records the comm's onto a Comm's table.
If I do hold an email address for them, there is another button that compiles the emailable version as above.
If however, I do not hear from them with a 90 day time, I can send them a chaser email or letter, but it is not attaching their Material List, its attaching a Material List, but a different supplier it but it does not match their supplier id, if that makes sense.
I have tried to look into the details in the build view, but I am not sure if I can identify where it is pulling the supplier ID from.
I am not sure how to rectify it as I can't see where it is pulling the supplier ID from, it is adding the comms letter(or email) to the correct supplier id. I thought I would be able to see OK it should be pulling the supplier ID from the form, I can't find where its getting the wrong supplier id from.
I hope somebody can help me please?
Thank you in advance
Clair
