Help with Lookup

Help with Lookup

Hi

I need a bit of help as I'm not too good with the scripting.

I have a form (Form1) with a column called "item name" .

I have another form (Form2) and I want to do a lookup depending on a radio button selection.

If button is "recipe" then get Lookup from form1.item_name (this is fine and working)

but if button is "Combo" the get List from form1.item_name, + the "name" list from this from From2.

Is this possible ?

If I cannot get this working, can I create a database where I can merge both fields, which can then be selected by the lookup.

Mick