hi,

On 09.03.2010 11:21, Revned wrote:
can anyone help me figure out how can I design my query and my form/subform
that when in my tblPayment field name AmntPaid equals to tblOrder field name
Amount, access will automaitcally set the field name Status to Yes.
This makes not really sense. How do you know which payment matches which
order?

btw, your tables are not well designed.

I have a table tblOrders
CustomerName DateOrder RefNo Amount Status
I have a table tblPayments
CustName Datepaid PaidRef AmntPaid
There should be a table Customer which should referenced in both tables
instead of storing the customer name reduuntantly.


mfG
-- stefan --