custom fields - "order" (table) in checkout conditioned by "product" (table) specifications
"display limited" - how to select another custom field from a different table
-- HikaShop version -- : 2.2.3
-- Joomla version -- : 2.5
Hi,
I have this specific case which require:
Multiple products/plans defined
* Cleanse 1, Cleanse 2, Cleanse 3
Each product/plan has multiple variants
* Cleanse 1 - 1 Day Cleanse
- 2 Day Cleanse
- 5 Day Cleanse
* Cleanse 2 - 1 Day Cleanse
- 2 Day Cleanse
- 5 Day Cleanse
and so on ...
For each variant will correspond a specific number of deliveries
* Cleanse 1 - 1 Day Cleanse - 1 delivery
- 2 Day Cleanse - 2 deliveries
- 5 Day Cleanse - 3 deliveries
* Cleanse 2 - 1 Day Cleanse - 1 delivery
- 2 Day Cleanse - 2 deliveries
- 5 Day Cleanse - 3 deliveries
On Checkout form, specific to each plan/variant, the user should have the possibility to specify each delivery date for the deliveries
(for example if the user will go for Cleanse 1 - 2 Day Cleanse, he should be able to select two delivery days, one for each delivery)
What I've done till now was to add a custom field to "product" table defined as a Single Drop-down with specific values (Number of deliveries - 1,2,3) and selected Front-end / Back-end which allowed me to go in Back-end and specify for each variant the specific "Number of deliveries" and at the same time the specified value was showed in the Front-end as "Specification - Number of Deliveries (value)".
In order to allow the user to set specific dates for the delivery at the checkout form I need to use the "order" table custom fields.
How could I make the link between the "product" table and "order table" because if I use the "order" table I can`t use the option "Display limited to" on the "product" table.
Thank you
