Viewing Related Records
I have items in a stock database and on each record I want to show a list of related items from the same database.
I would like to be able to select a stock code to add to this list and have it look up the description and price. I also want to be able to click to go to one of these related items.
What is the best way to do this as I have been struggling so far.