In a database I have to link three fields together, stock id, stock category and stock item. I want to enter in the stock id on a form and in the fields next to it i want the correct stock item and category that piece of stock falls into displayed automatically next to it.
Cheers
Strongy.