I have a database for managing information for subcontractors that we use in our construction business. One of the tables in the database is Contacts which includes the contact name, email address, cell number and the company ID that they work for. There can be multiple contacts for a particular company.
Another table, Project Bid List (I wish I was more creative with my table naming), contains information on particular projects we are pursuing in regards to the subcontractors who we are soliciting for pricing. When I enter the information for the project in my form, I pick the project number, the type of subcontractor work, the subcontractor company name and the subcontractor contact name among other things. See attached screenshot of the entry form.
I use a different set to generate reports showing company and contact information and with Netmailer (with varying degrees of success) to send bulk emails for general communications with the subcontractors. See attached for the set structures of the sets that I am using.
The problem I have is that the contact�s cell number and email that Alpha is including for the report and for Netmailer is not necessarily the email of the contact person that I entered in the Project Bid List table but the email of the first contact entered in the Contacts table for that particular company (see attached report � Al Raffin�s info cell number and email is wrong). How do I get Alpha to link the correct email and cell phone with the contact name I enter into the Project Bid List table?
Thanks for the help,
Rich
Another table, Project Bid List (I wish I was more creative with my table naming), contains information on particular projects we are pursuing in regards to the subcontractors who we are soliciting for pricing. When I enter the information for the project in my form, I pick the project number, the type of subcontractor work, the subcontractor company name and the subcontractor contact name among other things. See attached screenshot of the entry form.
I use a different set to generate reports showing company and contact information and with Netmailer (with varying degrees of success) to send bulk emails for general communications with the subcontractors. See attached for the set structures of the sets that I am using.
The problem I have is that the contact�s cell number and email that Alpha is including for the report and for Netmailer is not necessarily the email of the contact person that I entered in the Project Bid List table but the email of the first contact entered in the Contacts table for that particular company (see attached report � Al Raffin�s info cell number and email is wrong). How do I get Alpha to link the correct email and cell phone with the contact name I enter into the Project Bid List table?
Thanks for the help,
Rich