Monthly invoice

[ritev25]

Hello,
I want help with my ms Access database table. It is for ethernet and television provider.
I have two tables and I want to connect them and to make monthly invoice.


One of the tale is for clients. In it there are 5 fields
· Id client – AutoNumber – PrimaryKey
· Name – ShortText
· Family – ShortText
· City – Number – LookUpWizzard
· Service – Number – LookUpWizzard
The other tale is price + service and it there are 3 fields
· Id_service – AutoNumber – PrimaryKey
· Service – ShortText
· Price - Currency
I have made querie with this two tables and from it report. I want to make every month to come out invoice.
Thank you very much for your help.

[pbaldy]

Did the professor suggest an invoice table as well? I would create invoice transactions from those tables, my report would be based on the invoice table.

Most of us won't use lookup fields:

http://www.theaccessweb.com/lookupfields.htm

[ritev25]

Thank you very much for your answer. I want to make a simple database. I want to make a monthly invoice, which could be paid through this system and to have a report or a table, from where I can filter, the unpaid invoices.

[pbaldy]

I don't see how you track that without a table for invoices. How do you know which are paid/unpaid without a record of them?

[orange]

I agree with Paul.
Sounds like Customer orders a Service and receives an Invoice (for that/those Services)

--draft business rules:
-a Customer may order 1 or Many Service(s)
-when Service(s) is performed an Invoice is presented to the Customer
-a Customer pays the Invoice

Seems Invoice is central to your projec.t.

Many will avoid Lookups at Field Level!!

Good luck with your project.