Topic: Customer Invoices
Simple invoicing database. Also you can to print the invoice.
Download:
http://myvisualdatabase.com/database_ex … nvoice.zip
Screenshots:
My Visual Database → Database applications → Customer Invoices
Simple invoicing database. Also you can to print the invoice.
Download:
http://myvisualdatabase.com/database_ex … nvoice.zip
Screenshots:
I am trying to create a Money Receipt Printout, based on this program. However, the data is not loading correctly, and showing an error message. Where I am going wrong? Please help.
Hi eyeman303, for the first pic you sended, it's because you probably use letter on calculated field, or there is no numeral or number default value on a calculated field
Please attach your project, I will test it.
I studied the Simple Invoicing Database and want to understand how the table 'bills" gets the id_clients input? FrmService inputs are saved in table "bills" and frmService does not include any client reference. Add Services button in frmClient opens the frmService. Does this somehow add the client details to the bills table?
Hello Eyeman,
The data structure defines a one-to-many relationship between 'clients' and 'bills'.
The form 'frmservice' can only be accessed through 'frmclient' which already knows the clients.id. Therefore, when the form 'frmservice' is opened, clients.id is passed through and used to automatically generate (and save) the foreign key (bills.id_clients) without you having to do anything.
This is 'standard' MVD functionality and one of its main strengths.
Derek.
Hello Derek,
This is great. Let there be table_1 and table_2, with a field id_table_1 in table_2. Inputs in form_1 are saved in table_1 and those from form_2 are saved in table_2. As a general rule it would mean that any button on form_1 that opens the second form_2, will automatically know form_1.id and populate the foreign key table_2.id_table_1 and there is no need to create a drop-down object in form_2 to select id_table_1. Have I understood correctly?
Thank you for explaining the principles of MVD.
Hi,
Yes, you've got it.
Derek.
How can I select all item tablegrid1 from service and push botton ok to save table bill ?
thanks you
How can I select all item tablegrid1 from service and push botton ok to save table bill ?
thanks you
I made an example for you. You can select all items using Ctr+A, or click+Shift(Ctrl)
Thanks You Verry Much Drive Soft.. Excelent...
Hi,
I just want to know what does the $ symbol and Line13 mean, in the ReportSQL query Line13 (frmClient.Button4)?
Eyeman
Hello Eyeman,
In an sqlquery or reportsql statement, you've probably seen something before like ........ where clients.id = {edit1}
But in this example, there is no {edit1} - the clients.id isn't in any edit field on 'frmclient'.
However, it IS being held 'internally' (because that's how MVD links through from 'form1' to 'frmclient' with the record selected from form1.tablegrid1).
So, $id is simply the way of telling the query to use the 'internally' held id.
Hope that makes sense.
Derek.
Hello Derek,
Now I understand clearly, what the symbol signifies. Thank you once again, for helping me learn.
Regards,
Eyeman
My Visual Database → Database applications → Customer Invoices
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi