In designing a grid on a form that uses 3 tables, how does one set up the properties correctly so that when you input a value in a column, it will cause the next column to display the value as determined by the tables indexes... ie: say you input the number 1 in the column called Part_no, and then want the column called part_desc to autofill
from another table.

my current properties are so:

GRID:

Childorder: Tr_no
Linkmaster: Service
RecordSource: inv_parts
Allownewrecord: .T.

Column 1
header: tr-no
controlsource: Service.tr-No
text1: service.tr_no
NOTE: THIS COLUMN FILLS IN CORRECTLY!

Column 2:
header: Part No
controlsource:inv_parts.part_no
(user input)
Text1:
ControlSource:inv_parts.part_no

Column3:
header: Part Description
controlsource:Parts.part_desc
text1:
controlsource:parts.part_desc

this column does NOT fill in auto.. which is what i want it to do..
do i need to put a Locate function or something in the Valid or Click Property?

Also, Which property does one set to show ONLY records that match the Tr_no in the above example??

MMTIA