L
Lainni
What I think I need help with:
I need an update query that will add fields to a new record without me
having to prompt it or an append query that will add the complete record to
an existing table.
Here is the actual situation:
I have been working on this problem for a month, I got some help in figuring
out the design of the tables but I am once again stumped. I have a database
that tracks supplier contracts. These contracts are signed for 5 or 6 years
but they can potentially expire every 12 to 18months if the sales goal is not
met. I want access to calculate each period's expiration and the sales goal
that goes with that period. With that in mind and with the help of someone
who studied databases, I set up two tables:
tblContract
ContractID
SupplierID
DateSigned
Goal
NumberOfPeriods
tblAgreement
AgreementID
ContractID
Period
For every Contract, I put in 6 or 7 records in to the Agreement table for
each period. Instead of this, I would like to just provide the information in
the first table and have access create each records and calculate the start
and end date for each period. I want to have a record of each period not just
the current period, that is why I need to save the information as a record
instead of just using a query to calculate the current period each time it
runs.
Any help you can give me will be greatly appreciated, I have stumped on this
point all weekend.
Thank you,
Ini
I need an update query that will add fields to a new record without me
having to prompt it or an append query that will add the complete record to
an existing table.
Here is the actual situation:
I have been working on this problem for a month, I got some help in figuring
out the design of the tables but I am once again stumped. I have a database
that tracks supplier contracts. These contracts are signed for 5 or 6 years
but they can potentially expire every 12 to 18months if the sales goal is not
met. I want access to calculate each period's expiration and the sales goal
that goes with that period. With that in mind and with the help of someone
who studied databases, I set up two tables:
tblContract
ContractID
SupplierID
DateSigned
Goal
NumberOfPeriods
tblAgreement
AgreementID
ContractID
Period
For every Contract, I put in 6 or 7 records in to the Agreement table for
each period. Instead of this, I would like to just provide the information in
the first table and have access create each records and calculate the start
and end date for each period. I want to have a record of each period not just
the current period, that is why I need to save the information as a record
instead of just using a query to calculate the current period each time it
runs.
Any help you can give me will be greatly appreciated, I have stumped on this
point all weekend.
Thank you,
Ini