I already have a sales DB made up of CONTACTS, COMPANY and bridge file (REALTIONS).

Would like to add an extra file called DEAL PROPOSAL. Obviously, the DEAL PROPOSAL is a file where I can produce a proposal that would be related to CONTACT(S) and COMPANY(S).

I'm stumped...I can't figure this one out!

My guess:

CONTACTS file to the DEAL PROPOSAL file would be many-to-many

COMPANY file to the DEAL PROPOSAL file would be one-to-many

or

RELATIONS file to the DEAL PROPOSAL file would be one-to-many

: Whew!

each proposal would only have one person it is sent to right. So you have a one-on-one from PROPOSALs to RELATIONS based on relationID. RELATIONS in it's own right is related one-on-one to COMPANY and CONTACT.

Throught he prop-rel relationship you can display information from the company and contact tables.

if the releationship is a one-to-one from PROPOSALS to RELATIONS...how do I create a script that would generate a new DEAL Proposal Record based upon the correct relationship to the CONTACT and COMPANY?