S
SL
I am taking over a db used to track contracts and
agreements. It's a simple setup with a table for
CompanyInfo and one for AgreementDetails with smaller
tables for combobox selections. The AgreementDetails table
has many fields but depending on the AgreementType only a
subset is prompted for during data entry by means of
different forms. Users want the ability to query the db
based on different criteria. There is Query by Form setup
to filter the data. But they want the ability to use that
query result to go back the other way and display the full
details. So say they want all agreements that occurred
between 1/1/02 and 6/30/02. Then they want to display the
information in a form so that the appropriate records are
displayed based on the AgreementType. Does this make sense
and can someone give a newbie some pointers on how to
accomplish this?
agreements. It's a simple setup with a table for
CompanyInfo and one for AgreementDetails with smaller
tables for combobox selections. The AgreementDetails table
has many fields but depending on the AgreementType only a
subset is prompted for during data entry by means of
different forms. Users want the ability to query the db
based on different criteria. There is Query by Form setup
to filter the data. But they want the ability to use that
query result to go back the other way and display the full
details. So say they want all agreements that occurred
between 1/1/02 and 6/30/02. Then they want to display the
information in a form so that the appropriate records are
displayed based on the AgreementType. Does this make sense
and can someone give a newbie some pointers on how to
accomplish this?