Hi
I'm using a database for business to write a sort of letter for some other entreprises along a defined road.
In the header I choose from a combo box the sender and in a second combo box the recipient for the delivery. Both boxes are bound to the table tblAdresses.
By clicking on the Send-Button the filled-out form is saved and the report of it is prepared to be mailed. I enter all the recipients and it's done.
I'm now looking to automatize this so that Access knows who to send the report to depending on who I choose as sender and as recipient in my form.
I created a new table tblMail containing 3 fields: Sender; Recipient; Mailadresses;
I build it up like that: for instance I have 4 possible adresses 1-4:
1 - 2 - adresses
1 - 3 - adresses
1 - 4 - adresses
2 - 3 - adresses
2 - 4 - adresses
3 - 4 - adresses
So like that every possibility is covered.
So how do I realize the code that he looks up between the chosen sender/recipient and my table tblMail? My problem now is that the table is commuative but like that I already have 1035 entries in it.