Question Making an Invoice (1 Viewer)

viv345

New member
Local time
Today, 19:44
Joined
Feb 15, 2019
Messages
1
Sir,

I tried to make invoice (format attached) but I am unable to add data in table and in Reports. I would to know on which step I am doing wrong.

Thanks
 

Attachments

  • Form.jpg
    Form.jpg
    36.3 KB · Views: 54
  • Report.jpg
    Report.jpg
    31.7 KB · Views: 44
  • Database1.accdb
    1.1 MB · Views: 47

plog

Banishment Pending
Local time
Today, 09:14
Joined
May 11, 2011
Messages
11,638
You've done a lot of steps incorrectly. High Level--> you have an unbound form which means all the data you type into it goes nowhere. You should use bound forms, that way the data automatically goes into the tables they are based on. However...

You haven't set up your tables correctly. You have 1 table for a system that requires at least 2. You need a table for invoices (Invoice Number, Date, To, Address) and a table for Items (S. No, Particulars, Quantity, Rate).

Databases aren't spreadsheets they require a different way of thinking. I suggest you read up on normalization (https://en.wikipedia.org/wiki/Database_normalization). That's the process of setting up tables correctly. Once you have done that,f I suggest you manually put in data into those tables, then you create your reports and then you focus on forms.

So, read up on normalization, give it a shot on your data, then post back any issues you have with just that. Let's hold off on forms for now.
 

Users who are viewing this thread

Top Bottom