As I said at the beginning I will be needing premier support to help me add a verify email function to the application/payment process. Quite possibly for this issue as well now.
First I will try and explain further.
Ive attached screen shots of the tables used for this in the Database.
The members, properties and rtm_companies tables collect the data from the Application form using three 'insert record behaviours'. The submission of this form also triggers the Add to cart behaviour'
So, the product is the membership. So the only reason I'm trying to relate the rtm_companies table to the product(membership) table is so I can bind the 'Amount of Flats' ( from the rtm_companies table) to the 'Quantity column' in the Add to Cart' behaviour.
how else would I get the 'Amount of flats' value from the rtm-companies table into the 'Quantity' column in the 'Add to Cart' behaviour?
I think my general understanding of SQL and PHP is half the problem here so I apologise for that.
Everything seems fine until I try and join a second table in the recordset ( sql statement ) that is used to bind data to the Add to cart behaviour, which comes from the application form.