Use result of a control to find the data to populate a 2d control

  • Thread starter Thread starter tonyaims
  • Start date Start date
T

tonyaims

Have a database design that has cutomers, vendors defined
in tables that contain key info for each. The tables
include an ID field(eg: customerID) - the datatype is
autonumber. Three questions/problems:
1. Have a form that needs to display customer ID(or
vendorID). Want to use a combo box to display the customer
or vendor name. User selects the name then I want to find
the ID that corresponds to the selected customer name and
enter only the ID in a second control in the form. The
idea is to have customer or vendor name stored in only 1
place and store customerID or vendorID in tables that need
to identify the customer or vendor.
2. Would like to enable the user to enter a letter(or 2)
to populate the combo box with a subset of all customer or
vendor names(eg: only names starting with d, de, des,
etc.).
3. Other forms want to select data from multiple sources
(say POs, customers, vendors). In this case the PO record
contains the customerID and the vendorID. I want to use
the ID to find the right record and populate the form(or
report) with the name not the ID.
Thanks in advance,
Tonyaims
 
Back
Top