Help with running total

[sconnors]

You are trying to relate your autonumber ID field in p.o. to p.o. number in payments. When you use auto identity fields, they should be independent of the data so there would be no relationship. Relate p.o. number to p.o. number

Is this how it should look?

[Preston]

Yes. Now, vendorid should be in putcase orders, not vendorname. And kill the space in Purchase Orders. TPurchaseOrders, for example.

Also, I noticed you have a blanket/normal field. If you can have multiple invoices against a blanket p.o., you need a separate Invoices table.

[June7]

Did you read post 15? PONumber in [Purchase Orders] must now be defined as the primary key.

Suggest the names be slightly different to avoid confusion in queries. Something like PONumber_PK and PONumber_FK.

Same with VendorName. Since the VendorName field in [Purchase Orders] doesn't really have the name, just the ID, maybe VendorNameID or use the PK and FK suffixes.