var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Insertion of new Records
I guess this is a newbie question, so here goes.
I have two tables; Clients and Invoice
I have one Form called; NewInvoice
Now, I want to create invoices for multiple clients at once.
so in my NewInvoice form I have a Listbox which lists all the clients.
I have enabled multiselect to SIMPLE.
On my right side, I have a TextBox called 'InvoiceAmount' where I can type in an ammount. And then I have a button called 'AddNewInvoices'.
How do I go about inserting new records into Invoice DB with the cliendIDs selected from the ListBox?
When creating the listbokx (using a wizard) - I was asked if I wanted to remember selcted items for later use..... so I answered yes.
Any help apprechiated!
I would do a loop and insert for each selected item.
for x = 0 to CustId.ListCount - 1
set qdf=dbs.createquerydef("","Insert into Invoices ( Balance, CustomerId ) Select " & Balance & ", " & CustId.Selected(cnt) & ";")