I'm going to create a demo ( test ) project,just to see it I'm understanding things correctly.
I'll have 3 tables
2- Client Contact
3- Welcome Letter
I want to make sure that my key fields are correct, here is how I'll be setting it up.
The Contact field will have a PK and the Client Contract & Welcome Letter will have a FK
So it should look something like this...
The Welcome Letter for the most part will be a standard letter with most of the info coming from merge fields and the contract other then the signature and a few other info will also be for the most part merge fields.
I want to be able to go back into the welcome letter and search for ID 3 that n the contract is John Doe and search in the welcome letter, put ID 3 and bring up a match of the welcome letter for John Doe.
Any and all help with be GREAT!
Thank You All...