about making invoices

[Guest]

Im a student in school trying to make invoices for a company. I made a
customer table with a customer ID set as primary key and is autonumber. I
input the customer general information into that table. Then i made a invoice
table. I made the primary key Invoice Number and i put customer ID in that
table also. I then put the invoice general information into that table. Now I
made a customer form using the customer table. Then i made a invoice form
using the invoice table. I made a query with both of the tables(customer and
invoice)I set parameters to InvNum and integer. then for criteria under
Invoice Number where i added to the query i put "@InvNum" so when i make a
report it will prompt for the invoice number and i can type it in and then it
will automatically fill the information in for the report(as for as customer
information and invoice information)

 

[John Vinson]

Im a student in school trying to make invoices for a company. I made a
customer table with a customer ID set as primary key and is autonumber. I
input the customer general information into that table. Then i made a invoice
table. I made the primary key Invoice Number and i put customer ID in that
table also. I then put the invoice general information into that table. Now I
made a customer form using the customer table. Then i made a invoice form
using the invoice table. I made a query with both of the tables(customer and
invoice)I set parameters to InvNum and integer. then for criteria under
Invoice Number where i added to the query i put "@InvNum" so when i make a
report it will prompt for the invoice number and i can type it in and then it
will automatically fill the information in for the report(as for as customer
information and invoice information)

Umm... do you have a question?

My only comment is that in order to get a parameter prompt you need to
use a criterion in square brackets such as

[Enter Invoice Number:]

rather than @InvNum.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps