I would think this would be easy, perhaps I am missing what function to use.

Lets say I have one table.. called products.

The Products table has all of the item numbers, their item description.... along with other fields.

Same Table...2 new fields.

1st field: is a "you may also like"..which is a dropdown list based on all available Item Numbers.

2nd field: autopopulated item description of what was chosen in the first field.

So basically an old fashioned excel vlookup.

How would I do the lookup of the Item description, based on what Item number they chose in the first field?

Remember, it is all one table....

If it's all in one table, then it will be limited to one "you may also like" item per item.

As for your question: it's basically an old fashioned self-join relationship - you don't need to lookup anything.