G
George
I am now working with old DB that they want a new table
for:
Old: Contracts Table
Contract number
Company name, address, phone, contacts....
City of Contract
Fees Table
Contract number
Company name
City of Contract
124 fields of different Fee Amt
They want a table with 124 Fee codes (One for each Fee Amt)
to use as a pick list of what was charged to a Contract
number by Company by City
Could have more than one Contract number for a company for
a city - But different Fee Amt
HELP!
for:
Old: Contracts Table
Contract number
Company name, address, phone, contacts....
City of Contract
Fees Table
Contract number
Company name
City of Contract
124 fields of different Fee Amt
They want a table with 124 Fee codes (One for each Fee Amt)
to use as a pick list of what was charged to a Contract
number by Company by City
Could have more than one Contract number for a company for
a city - But different Fee Amt
HELP!