asked on

One to Manny???

I'm going to create a demo ( test ) project,just to see it I'm understanding things correctly.
I'll have 3 tables
1- Contract
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...

Fields.png

North2Alaska

The only thing I see as questionable is the Many to Many relationships. Is it possible to have a single letter for multiple contacts? A single contract for multiple contacts?

If the answer to these questions are No, then you've hit it right on the head.

noad

ASKER

A contact can have multi letter & muti contracts...

Should that not work like i have it?

North2Alaska

Yes, what you have is correct. What I was asking about is the reverse. Can a single contract or letter be assigned to multiple contacts. So that you end up with a many to many relationship.

noad

ASKER

But I don't want that correct?
I want to end up with one to many.

ASKER CERTIFIED SOLUTION

North2Alaska

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial