Form Design

[Mihail]

Just realized that I should have said that each "Batch of Donations" must have a unique Batch Date

This is another business rule
This time your approach is OK. You have ONE BatchDate TO MANY donations relationship.

Note please that you always should use a NUMBER (preferable an AUTO NUMBER) as PK, even if the data in a field has no duplicates (I refer to your BatchDate table where, if I remember well, you have the field BatchDate - of type Date/Time - as the primary key).

 

[Bob87476]

Thanks or your encouragement.
I do in fact have an autonumber field as the PK for Batch Date table.
I have now amended the form to sort the donations on DonationID (Desc) so the latest donations are at the top. I also have a
Private Sub Detail_Click()
Me.Child.Requery
End Sub



So if you imagine inputting a "Batch" of donations using a pop up form with the frmqryDonationsByBatchDate in the Background and I have just entered a donations from one individual but to more than one fund. Lets say 3 for example. After I click to get the refresh I have a list of three donations from the one donor. How difficult would it be to show the total of those three donations by the one donor.


Thanks.

Bob

 

[Mihail]

Is there any question ?
Note please that my English is very limited. So, if you wish to ask something do this in very simple words. And put a "?" sign at the end

 

[Bob87476]

The idea I had is too complicated to ask just a simple question but I have found a way to solve my problem.

Thanks again for your help.