Making Contracts, Terms, & Signatures

[Douglas_English]

3 Tables..

• Contracts
• Terms
• Signatures

Workflow Process..

1. create contract
2. select contractee
   1. client
   2. valet
3. Separate table of 'terms' that can be updated (when a term is updated contractee must re-sign)

Do they sign off on each term or does one contract, with related terms, once that is signed it counts for all the terms.  In this case will not need 3rd table for signatures, just the signature on the contract.  

So the contract has related terms... for valet there is a set of terms, for client there is set of terms.  Terms have a column "type" to distinguish.  How can I get all the proper related terms when creating contract?

[Joseph_Seddik]

When you update a term for a particular contract, wouldn't that affect all other contracts that contained this term? 

--

The related terms can be retrieved by: 

SELECT(Terms[termID], "client" = [type]) and
SELECT(Terms[termID], "valet" = [type])