J
justin
Ok, so I'm starting over from scratch. It seems like the
more I read the more confused I become.
Anyway, I need to create this database where we can input
data about our contracts (specifically; contract#,
contract name, our contact person, their contact person,
date recieved, start date, end date, route date,
completion, $ amount, contract type, account#, PO#(if
needed), and who entered the data), then we need to be
able to see which contracts have not yet been completed.
That is to say, we need to track our contracts to know
which contracts have all the necessary signatures, and
which ones are still out in the field needing to be signed.
So far, I've created two tables. One ContractType, has one
field with the same heading, and twelve
different "records", one for each type of contract.
The other table, ContractInfo, has a field for each of
those catagories I've listed above.
We've created a field labeled "Completion" which I've made
into a Yes/No entry. I did this thinking this is what we
would use to check to see if the contract has all the
required signatures. Does this make sense?
Basically after this point, I'm stuck. What else needs to
be done, so we can enter in the data, and search the data
to see which contracts are still in the field? I know that
I probably need to create relationships between the
tables, but what am I relating, and why? It's just not
making much sense to me.
Thanks again for all your replys and comments. Hopefully
I'll be able to finish this project sometime soon.
-Justin
more I read the more confused I become.
Anyway, I need to create this database where we can input
data about our contracts (specifically; contract#,
contract name, our contact person, their contact person,
date recieved, start date, end date, route date,
completion, $ amount, contract type, account#, PO#(if
needed), and who entered the data), then we need to be
able to see which contracts have not yet been completed.
That is to say, we need to track our contracts to know
which contracts have all the necessary signatures, and
which ones are still out in the field needing to be signed.
So far, I've created two tables. One ContractType, has one
field with the same heading, and twelve
different "records", one for each type of contract.
The other table, ContractInfo, has a field for each of
those catagories I've listed above.
We've created a field labeled "Completion" which I've made
into a Yes/No entry. I did this thinking this is what we
would use to check to see if the contract has all the
required signatures. Does this make sense?
Basically after this point, I'm stuck. What else needs to
be done, so we can enter in the data, and search the data
to see which contracts are still in the field? I know that
I probably need to create relationships between the
tables, but what am I relating, and why? It's just not
making much sense to me.
Thanks again for all your replys and comments. Hopefully
I'll be able to finish this project sometime soon.
-Justin