Form (table?) setup

  • Thread starter Thread starter Maryann
  • Start date Start date
M

Maryann

After perusing MS Access 2000 help and newsgroups I am
still unsure how to begin.

I have a table for invoices, table for receipts to
invoices, and table for payments to employees (paid on
invoices). There are multiple receipts and multiple
payments (driving payroll) to a given invoice.

What is the best method to coordinate this such that I
might retrieve individual receipts and payments against
and invoice.

I am a blank sheet, can someone suggest an approach?

Thank you to you MVP gurus.
 
Setup your main form on the invoices table. Then setup
subforms on the receipts table and the payments table. I
am assuming there are invoice numbers in each table that
relate everything. Make sure you set the links for the
child and master fields in the property sheet for each
subform.

Hope this helps!

KW
 
Back
Top