Proper way to update records

[todmac]

I have a database I have built that houses Warranty claims. They are uniquely identified by claim number.


We regularly get a cheque which has certain dollar amount that need to be applied to certain claims.

I want to write a procedure where the user enters the cheque number and then in a table enters the Claim numbers and amounts. Once the procedure runs it would find each Claim Number the user entered and update the claim with the cheque number and dollar amount.

I am not looking for the coding per se, but the best approach to take in order to achieve this. Table, schema, query, string?

So far I have:

Private Sub Command6_Click()
Dim CQNum As String
Dim WoNum As Integer
Dim Amount_Paid As Currency
CQNum = InputBox("Please enter the Cheque Number you wish to Process.", "Cheque Number")
If StrPtr(CQNum) = 0 Then
    MsgBox "Cancel Was Selected"
    Exit Sub
        ElseIf CQNum = "" Then
        MsgBox "You did not enter a Cheque Number"
        Exit Sub
        End If

DoCmd.OpenTable "Cheque", acViewNormal, acAdd
 
End Sub

[June7]

Once check could be for multiple claims? I suggest a table for Receipts and a related table for Receipt Details.