I think I need a subform

[Kelly@AllenEnt]

Hello,

I would like to track payments against a job. Each job may have many invoices that are billed against it. I have an "ORDER" table with "ORDER #" as the primary key. I think I need to make a "PAYMENT" table with the "INVOICE #" as the primary key. What I would like to do is enter a payment and the payment automatically deduct from the "OUTSTANDING" column. Am I on the right track? Would a Form with a subform be the appropriate course of action?

~Kelly

 

[MStef]

Yes, it is O.K.
Make 2 tables (ORDER table with Primary key ORDER,
and PAYMENT table with Primary key INVOICE). In th
PAYMENT table put the field ORDERsub (Foreign key).
Make a RELATIONSHIPS (ORDER table : PAYMENT table
1: more) via ORDER field and ORDERsub field.
Make 2 forms on 2 tables, frmPAYMENT put in frmORDER
as a subform and populate the properties LINK CHILD FIELDS
and LINK MASTER FIELDS (for the subform).