How to add Single subform Row of Data based on each input of 1 field (Barcode scan)
Hello,
I can't seem to get my head wrapped around getting a subform to populate data another form properly.
I seemed to have coded something that technically populates, but it creates multiples of the same data, when I only need 1 row per entry of data in a single field, which is essentially a barcode scan field.
Form 1:
Called: Add Product
Has:
Prod Barcode
Product Name
Price
Form 2:
Called: Create Sale
Has:
Single Field called Main Barcode - this field will get the barcode scan, then be the lookup number of the product details above to populate the sub field.
Sub form called Sale Items with:
Sale Barcode
Sale Product
Sale Price
I looked at video tutorials and knowledge bases and have come up with the following workflow for user input:
prodinfo = Add_Product[prod_barcode == input.main_barcode];
prodrow = Create_Sale.sale_items();
for each prod_barcode in Add_Product
{
prodrow.sale_barcode = prodinfo.prod_barcode;
prodrow.sale_prod_name = bookinfo.prod_name;
prodrow.sale_price = prodinfo.prod_price;
prodsalecollection = Collection();
prodsalecollection.insert(prodrow);
input.sale_items.insert(prodsalecollection);
}
What happens is it actually puts an entry in, but like 15 rows of it in the sub form.
I only need to scan the product once, it populates the details in the subform and then I will have the main barcode field wipe and become the focus, ready to scan the next barcode to create the next row of data.
Anybody know what I did wrong or missed to have it create more than 1 row of the same data?
I also have a "Total" field where I coded that if the sale price sub form field is not null, to then add up each row price. the code:
var_total = 0.0;
for each sale_items in sale_items
{
if(row.sale_price != null)
{
var_total = var_total + row.sale_price;
}
}
input.main_total = var_total;
This doesnt update the total when the entries are inputted.