M
Mishanya
In most examples of databases I've found the next design of Field List in
forms:
SELECT Customers.CustomerID, Customers.CompanyName
FROM Customers
ORDER BY Customers.CompanyName;
while the scrolling list in the form shows the values of CompanyName field
from the Customers table.
1. When I try to use this command, the scrolling list shows both the
CustomerID and CompanyName fields. I've tried to copy exactly all the other
properties - still got the both. What's the trick?
2. Why using both the fields (the index and the actual value) in the command
instead of querying only the actual value field?
forms:
SELECT Customers.CustomerID, Customers.CompanyName
FROM Customers
ORDER BY Customers.CompanyName;
while the scrolling list in the form shows the values of CompanyName field
from the Customers table.
1. When I try to use this command, the scrolling list shows both the
CustomerID and CompanyName fields. I've tried to copy exactly all the other
properties - still got the both. What's the trick?
2. Why using both the fields (the index and the actual value) in the command
instead of querying only the actual value field?