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