CritterLover
Programmer
I'm using a TQuery for the Lookup AND Data. I tried using FAQ102-1212. In FAQ102-1212 the only reference give to using a SQL is the SQL:
Select OrderNo, CustNo, EmpNo, SaleDate, ItemsTotal from "Orders.db" Orders.
It worked fine with the Lookup as a Query, but won't work with the Data (Orders) as a Query. Any suggestions? Did I miss something in the FAQ? (I was unable to use the FAQ Reply option) My properties are as follows:
TDBLookupComboBox Properties:
DataSource is the DSQryOrders
DataField is EmpNo
ListSource is DSQryLookup
KeyField is EmpNo
QryOrders:
Database myData
SQL Select OrderNo, CustNo, EmpNo, SaleDate, ItemsTotal from "Orders.db" Orders.
DSQryOrders
DataSet QryOrders
QryLookup:
Database myData
SQL Select EmpNo, LastName, Firstname from employee.db
DSQryLookup
DataSet QryLookup
TDBEdit
DataField EmpNo
DataSource DSQryOrders
It will do the dropdown for the combo box, but acts like it's read-only and will not update (combobox, listbox-which I'm not using for this, or orders data). This FAQ worked fine until I made the orders data a query instead of a table. Am I missing the boat on something? Did I misread something in the FAQ? Is this a whole different ball game? Thanks!
Select OrderNo, CustNo, EmpNo, SaleDate, ItemsTotal from "Orders.db" Orders.
It worked fine with the Lookup as a Query, but won't work with the Data (Orders) as a Query. Any suggestions? Did I miss something in the FAQ? (I was unable to use the FAQ Reply option) My properties are as follows:
TDBLookupComboBox Properties:
DataSource is the DSQryOrders
DataField is EmpNo
ListSource is DSQryLookup
KeyField is EmpNo
QryOrders:
Database myData
SQL Select OrderNo, CustNo, EmpNo, SaleDate, ItemsTotal from "Orders.db" Orders.
DSQryOrders
DataSet QryOrders
QryLookup:
Database myData
SQL Select EmpNo, LastName, Firstname from employee.db
DSQryLookup
DataSet QryLookup
TDBEdit
DataField EmpNo
DataSource DSQryOrders
It will do the dropdown for the combo box, but acts like it's read-only and will not update (combobox, listbox-which I'm not using for this, or orders data). This FAQ worked fine until I made the orders data a query instead of a table. Am I missing the boat on something? Did I misread something in the FAQ? Is this a whole different ball game? Thanks!