Hi All,
Have a large database (approx 30 columns, hundreds of lines) and would like
to run a quick report that pulls important related information from the
databse via a key descriptor i.e if I have simple data like

Number Description Cost Delivery Qty
1 Egg 25 Yes 300
2 Chicken 30 No 500

So by choosing a line number, the remaining line information returns,
Description, cost etc returns into appropriate label fileds as below

Number 2 (line number chosen to view)
Description Chicken (these fields populate automatically)
Cost 30 (these fields populate automatically)
Delivery no (these fields populate automatically)
Qty 500 (these fields populate automatically)

Any ideas will be appreciated
Cheers
OzzyJim