Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

a guidance needed in the following code

Posted on 2013-01-22
3
137 Views
Last Modified: 2013-06-20
i have a following screenshot, whereas in one form, i need to add the products for single invoice and i can add multiple products.

I can create the new products and price easily, i am facing issue during insert/update, i am doing an insert into two tables rather in one. one for products and other for the invoice so 1 invoice can have n products,

i am having some issues in CRUD, need a bit of guidance in this

i know this will be asked [what you have done so far], honestly nothing, i need fresh idea where i should go ahead
color.bmp
0
Comment
  • 2
3 Comments
 
LVL 10

Expert Comment

by:stu215
ID: 38812141
What kind of problem are you having? Error?

- when you submit the form it should do 2 inserts, one into the header table and the other should loop over line items ( name, qty, price )...?  then return to a printable invoice page?
0
 
LVL 16

Accepted Solution

by:
Gurpreet Singh Randhawa earned 0 total points
ID: 38823713
i solved it
0
 
LVL 16

Author Closing Comment

by:Gurpreet Singh Randhawa
ID: 39261883
Solved by adding a different set to the post
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

CFGRID Custom Functionality Series -  Part 1 Hi Guys, I was once asked how it is possible to to add a hyperlink in the cfgrid and open the window to show the data. Now this is quite simple, I have to use the EXT JS library for this and I achiev…
Sometimes databases have MILLIONS of records and we need a way to quickly query that table to return the results me need. Sure you could use CFQUERY but it takes too long when there are millions of records. That is why SOLR was invented. Please …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question