Skip to forum content
My Visual Database
A Simple Solution for Creating Databases
You are not logged in. Please login or register.
Active topics Unanswered topics
Search options
smmh1010 wrote:Hi,
Is it possible to have the below scenario in MVD with no script if possible?
1- I have a form to create an invoice and consist of two parts, first part for invoice header and second part for invoice lines.
2- Getting all products in a list and can filter the list by name or code Then select one or many products once then add them to invoice form and enter the remaining required data such as quantity, discount etc.
3- After selecting products, I can add more or delete some products.
4- When I Click on save button, the program check that all required data in invoice header and invoice lines are entered (nothing missing) then update all related tables accordingly.
5- Tables should not be updated before step # 4.
Hi derek,
Thank you for your reply.
I do not see in your sample invoice that # 2,3,4 and 5 are achieved.
Regards.
Hi,
Is it possible to have the below scenario in MVD with no script if possible?
1- I have a form to create an invoice and consist of two parts, first part for invoice header and second part for invoice lines.
2- Getting all products in a list and can filter the list by name or code Then select one or many products once then add them to invoice form and enter the remaining required data such as quantity, discount etc.
3- After selecting products, I can add more or delete some products.
4- When I Click on save button, the program check that all required data in invoice header and invoice lines are entered (nothing missing) then update all related tables accordingly.
5- Tables should not be updated before step # 4.
Excellent approach especially the option 2 .
Thank you derek for your help.
derek wrote:Hi,
Looking at your screenshot, it's a bit unusual to have similar entities (Unit1, Unit2 and Unit3) all part of the same record rather than 3 discrete records and I would guess this is the cause of your issue, but it's a simple enough fix.
Can you attach your project (zip up everything except the .exe).
Then someone will be able to take a look and suggest fixes or alternative approaches.
Regards,
Derek.
Thank you derek,
The project is attached.
welcome everybody,
is there a way to solve the attached issue?
I prefer no-code solution if it is possible.
Thanks
Posts found: 5