R
R.T.
I ran into a uniuqe problem, that I'm hoping I can get a different
viewpoint on.
A year or so ago, I wrote a database application that pulls
Subcontractor informtion (address, etc) from a 'contacts' table and
combines it with information pulled from a 'project' table (Job
Number, contract amount, etc) and generates a 13-20 (depending on # of
line items) page subcontract. This works wonderful with a single
exception. Some of our subcontractors require specific wording to be
changed in the contract.
As a solution to this, I've created a table that houses the contract
broken down into sections numbers. A user can copy and change any
given section, and then choose the order and the sections to include
in the contract. My problem is that I can't grasp what I need to do
to add the specific vendor/project dynamic data into the contract
table. I've listed an example below.
Table - tblContractText
Key - 1
Text - THIS SUBCONTRACT, made this _______ day of ______________,
20____, by and between [Vendor info from tblContacs need to go here],
hereinafter called the Subcontractor, and ABC Company, hereinafter
called the Contractor.
Use - Yes
Order - 1
Ok, the above will print the text in the first position of the
contract. Any ideas as to how I can reference the vendor info from
the table?
A bit more info, the project and vendor used for the subcontract are
selected by selecting each from a listing of jobs, and a contact book,
respectively.
Of the roughly 15 pages of the contract, there are 6 or 7 sections
that require dynamic data. The majority of it would be at the
beginning, which brought to mind sub reports, but there is a few ares
right in the middle of the contract that require dynamic data.
Basically, what would be prefect, would be a method of treating the
data in the table as a formula.
Any takers?
viewpoint on.
A year or so ago, I wrote a database application that pulls
Subcontractor informtion (address, etc) from a 'contacts' table and
combines it with information pulled from a 'project' table (Job
Number, contract amount, etc) and generates a 13-20 (depending on # of
line items) page subcontract. This works wonderful with a single
exception. Some of our subcontractors require specific wording to be
changed in the contract.
As a solution to this, I've created a table that houses the contract
broken down into sections numbers. A user can copy and change any
given section, and then choose the order and the sections to include
in the contract. My problem is that I can't grasp what I need to do
to add the specific vendor/project dynamic data into the contract
table. I've listed an example below.
Table - tblContractText
Key - 1
Text - THIS SUBCONTRACT, made this _______ day of ______________,
20____, by and between [Vendor info from tblContacs need to go here],
hereinafter called the Subcontractor, and ABC Company, hereinafter
called the Contractor.
Use - Yes
Order - 1
Ok, the above will print the text in the first position of the
contract. Any ideas as to how I can reference the vendor info from
the table?
A bit more info, the project and vendor used for the subcontract are
selected by selecting each from a listing of jobs, and a contact book,
respectively.
Of the roughly 15 pages of the contract, there are 6 or 7 sections
that require dynamic data. The majority of it would be at the
beginning, which brought to mind sub reports, but there is a few ares
right in the middle of the contract that require dynamic data.
Basically, what would be prefect, would be a method of treating the
data in the table as a formula.
Any takers?