I am designing a form to assist the treasurer of our club to record bank deposits.
We have a calendar of scheduled events for the year. Every day has a fixed time for the events (from 1 to 4). Money is collected for each event and kept separately. Deposits are made once a week
My main table is “BankDeposit” with a multi-field key of DepositDate+DepositNumber.
The child table is “ActualEvent” with a multi-field key of EventDate+EventTime with a foreign key of DepositDate+DepositNumber to “BankDeposit”. It contains detail of the proceeds and several different discounts with a calculated net for each event.
I have a main form, Bank Deposit, with a sub form, Actual Event.
My idea is to have the user enter the Deposit Date & Deposit Number and then the range of dates/times of the events income included in the deposit.
Then I would like to be able to update the ActualEvent table with the Deposit Date and Number. Then I want to refresh the sub form so the detail of each event can be filled in. Detail of the proceeds for each day can then be entered and a total deposit calculated.
I am unable to create actions to accomplish the update and refresh the sub form. Please help.
We have a calendar of scheduled events for the year. Every day has a fixed time for the events (from 1 to 4). Money is collected for each event and kept separately. Deposits are made once a week
My main table is “BankDeposit” with a multi-field key of DepositDate+DepositNumber.
The child table is “ActualEvent” with a multi-field key of EventDate+EventTime with a foreign key of DepositDate+DepositNumber to “BankDeposit”. It contains detail of the proceeds and several different discounts with a calculated net for each event.
I have a main form, Bank Deposit, with a sub form, Actual Event.
My idea is to have the user enter the Deposit Date & Deposit Number and then the range of dates/times of the events income included in the deposit.
Then I would like to be able to update the ActualEvent table with the Deposit Date and Number. Then I want to refresh the sub form so the detail of each event can be filled in. Detail of the proceeds for each day can then be entered and a total deposit calculated.
I am unable to create actions to accomplish the update and refresh the sub form. Please help.