I'm trying to get a dbLookupComboBox to work with paradox tables and I'm have a teriible time. No matter how I set it up, I get a circular datalink warning.
My setup is like:
[tt]
DataSource1 -> Table1 = Work Locations
Fields = LocationName, Description
DataSource2 -> Table2 = Work Orders
Fields = LocationName, WorkDate
dbLookupComboBox Setup - look up location names
Listsource = DataSource1
ListFields = LocationName;Description
KeyField = LocationName
DataSource = DataSource2
DataField = LocationName
[/tt]
I don't see where I've missed a step. HELP!
Mahalo,
cg
My setup is like:
[tt]
DataSource1 -> Table1 = Work Locations
Fields = LocationName, Description
DataSource2 -> Table2 = Work Orders
Fields = LocationName, WorkDate
dbLookupComboBox Setup - look up location names
Listsource = DataSource1
ListFields = LocationName;Description
KeyField = LocationName
DataSource = DataSource2
DataField = LocationName
[/tt]
I don't see where I've missed a step. HELP!
Mahalo,
cg