J
Jacki
Hi.
I have a database that contains several tables. One
table (fees table) holds invoice dates, fees, etc. The
main table in the database also has a field for invoice
date. Difference: in the scheme of things the main
table has the one side of the many equation and the fees
table has the many. In otherwords for every one record
in the main table, there can be many records in the fees
table.
My quandary: Currently, a report is run to show all
current activities related to fees. Once done, a
secretary opens a form based on the main table, locates
the specific record for which there was recent activity
and inputs/overwrites the most recent activity for
Invoice dates. Yes...there needs to be a record of both.
Is there a code that I can write in an Update or Append
Query so that we can automate this task by simply running
the query? Please help. Thanks.
I have a database that contains several tables. One
table (fees table) holds invoice dates, fees, etc. The
main table in the database also has a field for invoice
date. Difference: in the scheme of things the main
table has the one side of the many equation and the fees
table has the many. In otherwords for every one record
in the main table, there can be many records in the fees
table.
My quandary: Currently, a report is run to show all
current activities related to fees. Once done, a
secretary opens a form based on the main table, locates
the specific record for which there was recent activity
and inputs/overwrites the most recent activity for
Invoice dates. Yes...there needs to be a record of both.
Is there a code that I can write in an Update or Append
Query so that we can automate this task by simply running
the query? Please help. Thanks.