Forms

[Bob2102]

I am using Access 2003. I designed a table for my painting business to keep track of jobs and invoices. In the table design I did...
Job,Store,Invoice #,date, amount. Now, when I did the form in Design I copied the Amount 5 times. When I went to put the price in the price showed up in all 5 amounts. When I went to put in another price that showed up and replaced the first price. Can someone tell me what I am doing wrong?
EXP..
Job Invoice (number) Amount (Currency)

 

[Remou]

I strongly recommed that you first look at the various templates:

http://office.microsoft.com/en-us/templates/CT101426031033.aspx?av=ZAC000

and also at the available sample databases.

 

[Bob2102]

Thanks for the help