Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Combo box - update
Name: noz786 Date: December 17, 2004 at 02:44:40 Pacific OS: XP CPU/Ram: 1024MB
Comment:
I have three tables.. Customer Table (with customer ID, firstname, surname, address, email etc...) Product Table (with the product details - there's only 2 entries here) Invoice Table (with all the customer details and product details they have bought... will be used to store all orders)
I have a form which allows you to enter new products and one to add new customers. I am trying to make another form which uses the already there customer details, and which includes a combo box picking which product they ordered (from the product table). This should then automatically update the entries in the Invoice table.
Is this possible? I'm not too sure in what way to link the tables and how to make this all work.
Name: secrets Date: December 18, 2004 at 12:35:08 Pacific
Reply:
it much depends on the invoice table you have not shown its design...? and what language you are using.... it can be done in more then one ways by using triggers in sql or by working only in front end language its not a big problem... explain it so that more help can be provided.
Summary: use a sql string that gets the value from each combo box and then shows the display in the flex grid, create a procedure that is run after either combo box has been updated in the prcedure get the va...
Summary: If it was the other way around, you could report a bug to Mozilla, and since Netscape is based on Mozilla, eventually it would get fixed. If you try reporting the IE behavior to Microsoft as a bug, yo...
Summary: Using a table as data source. I have 5 text choices in a combo box which will store the text in the relevant table OK. But how can I convert the text to numbers (as an option group would do)? Can anyo...
0 
