?The way you are tying a payment amount to an order is by the Amount?

Is there ever a situation when two orders have the same Amount?

Do you ever have a situation where someone pays less than (?!more than) the
full Order Amount?

I'll suggest that you take another look at the Northwind database that comes
with Access for a possible model of the data structure to use for an Order
application.

Good luck!

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.



"Revned" wrote in message
...
Hello everyone,

I have a table tblOrders
CustomerName DateOrder RefNo Amount Status

primary key: RefNo
Field type: Status - check box

I have a table tblPayments
CustName Datepaid PaidRef AmntPaid

primary key: PaidRef

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.

please can anyone help me.

thanks in advance, i appreciate