Hi,
I am making an invoicing database, So far I have the following tables & fields.
tblInvoices
invoice no (autonumber,primary key)
invoice date (date)
Description (memo)
amount (currency)
tax (calculated field)
total (calculated field)
customerID (foreign key)
tblJobs
Job Id
amount
customer ID (foreign key)
tblCustomers
Customer ID
Company
Billing Email
Billing Address
Active Customer
every month only two things change on the invoices. (1) Description (2) Invoice date
I want to create a form where I put the Description & Invoice Date then press CREATE INVOICES, and it creates invoices for all active customers.
It should pick up customer name & address from Customers table, and pick up total amount from Jobs table (the job that is relevant to that customer only)
I know what I want, but do not know how to do it, what type of queries I need to create and if there is another easier way of accomplishing the same thing.
Please treat me as a newbie as I am still learning Access.
I have Access 2010.