Many to many relationships

  • Thread starter Terrence Carroll
  • Start date
T

Terrence Carroll

I need to come up with a good design for a database addressing client payment
discrepancies. The main goals that I have are to track the number of issues
generated along with resolution status. I have an output file displaying
payment discrepancies by line item on an invoice (i.e. one invoice could have
many line items). Fields for the output file are as follows:
Customer Name, Account Number, Customer Number, Employee Name, Week of
Service, Invoice Number, Invoice Line Item, Date Payment Posted,Total Open
Account Receivable for invoice, Accounts Recevable Analyst
 
D

De Jager

Terrence Carroll said:
I need to come up with a good design for a database addressing client
payment
discrepancies. The main goals that I have are to track the number of
issues
generated along with resolution status. I have an output file displaying
payment discrepancies by line item on an invoice (i.e. one invoice could
have
many line items). Fields for the output file are as follows:
Customer Name, Account Number, Customer Number, Employee Name, Week of
Service, Invoice Number, Invoice Line Item, Date Payment Posted,Total Open
Account Receivable for invoice, Accounts Recevable Analyst
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Database design many to many relationships 4
SQL Question - restated 3
template creates invoice - how to create summary worksheet? 13
Mail Merge with a many-to-one report/query 1
forms, junction tables, and many-to-many relationships 1
Help with an account balancing database 4
record spanning more than one line 1
Query Help One-to-Many 4

Top