time & billing template database

T

Teonna

I have created the time & billing template database, and
everything works fine except the invoice function. How do
I save an invoice to a client? Any info would be helpful.
Thanks
 
M

Matthew Therrien

It is a little difficult to comment without seeing your
table(s) structure(s) - but making some assumptions about
Time and Billing Systems I have worked with - in your
table - we'll call it - tblInvoice - you would have a
ClientID field, which would be indexed and would be
related to the ClientID of your tblClients.
tblClients.ClientID would be in a one-to-many relationship
with the tblInvoice.ClientID. Have a look at the Access
sample Northwind database as the relationship between the
(Customer) Orders
and Customer tables illustrates this design structure
exactly.


Matthew
 

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

Why my invoice total show as error in TIme and billing template 1
Invoice in time and billing database 15
Access MS Access Time & Billing "total payments" question 0
Show Billing Period 3
Designing a Query or Text Box 5
Access Time and Billing Template 1
Getting started video taining 2
Time and Billing issue - print invoice only shows one invoice 4

Top