Adding a dropdown list with data from another table into a site view

[fred-the-coder]

Hi all,

I have a site view providing a list of items.
Fine.

In this site view, I want to add, beside the list of items, a combo field (dropdown list) listing data from another Joomla table.
How to achieve this?

1/ to retrieve the data, I can add a Custom get to add it in the site view.
There, I have already a dynamicGet of getListQuery kind, but I cannot add it in the site view as the main get is already setup.
Thus i will create a customGet for this.
Am i right here?

2/ then once, I have the data, shall I build the dropdown list manually as custom code? by generating the HTML code with PHP.
Or can I do it by using a JCB feature that I don't know?

Hope my questions are clear enough!

Thanks for your help.
Best regards.

[fred-the-coder]

FYI, I did, nearly, as I expected.

I.e.
1/ by adding a getCustoms in my site view, i was able to retrieve data from another Joomla table in my list view.

2/ to display the dropdown list I called the combo layout in the site view code (default.php):
LayoutHelper::render('joomla.form.field.combo'...)
There I had to rework the data from getCustoms to fill correctly the combo box.

Hope it helps