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
Dan Gilliland
ICQ# 15695715
"Man is still the most extraordinary computer of all."
John F. Kennedy (1917-1963)