construction of the Database

[Erictsang]

Dear all



I have a question in building up a database for payment record, to record if the payment is paid.
If the payment is paid, we have a record of the receipt.


a) i got a master table for all client details such as names, amount, payment mode

b) i made a query to sort and split another table from the master table- Payment for payment mode and amount

c) in this table, i convert it into a form and add a field - Receipt ( if the payment received i input the receipt no)

All can be joined by ID.

How can i make it work ?
Eric

[ranman256]

you just did.
the receipt button can print from the form
docmd.openreport "rReceipt",acViewPreview,,"[id]=" & txtID


on the master form, you can have 2 subforms....1 to show billing, 1 to show payments.

[Erictsang]

i have no idea why but they are not sync

[pbaldy]

What is not in sync? The report method shown or subforms? If subforms, the master/child link properties of the subform control(s) need to be set to the appropriate fields.

[Erictsang]

i double checked the file, and i found that i updated the master table and made a subform for payment where i have the i need t insert the receipt no

Somehow i found that the record is not updated. Say i imported more 10 records in the Master table, the subform is still remind the same. But when input the record in subform , say the payment amount and the receipt no. It reflected the master table
So strange

Eric