Board index » off-topic » Re: Lookup functionality
Re: Lookup functionality
2007-10-24 12:53:08 AM
Your question is not clear. Assume you are editing a customer table and
that the customer table contains a field named SalesTerritoryCode.
Assume you have a table named SalesTerritory that whose primary key is
SalesTerritoryCode and which contains the name of the sales territory
and other information.
If you create a lookup field in the Customer table that looks up to
SalesTerritory then you can select a SalesTerritoryCode from the
SalesTerritory table for the customer record you are editing. You
cannot change what is in the SalesTerritory table via the lookup field.
Bill Todd (TeamB)