Thanks for this Ray. Im now having difficulties in feeding the correct amount into the 'Quantity column. I have tried binding the amount from the value given in the application form but it stops the cart from working.
This is what I have:-
the product (membership) is in a Database table which the following columns. [ item_id, item_name, base_charge, per_flat_price, quantity, meta_keywords, meta_description ] If I create a recordset using this table only its fine but the quantity value is wrong as it is always 1. The quantity needs to be determined by the 'number of flats' the user enters in the application form ( where the 'Add to Cart' behaviour is attached )
I have tried joining the DB table that holds the value and then binding the value to the 'Quantity' column but it seems to break the cart function and just enters the form into the database but doesn't direct to the 'cart display page'
My thinking is that it is trying to retrieve a value that isn't there yet possibly.
Any ideas!
Thanks in advance!