checkout - custom field from a different table

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

Hi,
A solution can be to display your 3 delivery dates through your checkout, but if you want the number of delivery date fields to be adapted to the number of delivery that you've selected through your product page, you'll have to edit the code of the files of your "checkout" view of your front-end template through "Hikashop->Display->Views".

So the first thing would be to define the three delivery dates in the checkout form and after that go and modify/adapt the code ?
Could it be possible to give an example on how this should look ??

Thanks