Conditional Relationship/Lookups

Question

Hi all,

I'm just starting to use Access (i.e. no SQL experience), and was wondering if it was possible to do a conditional lookup.

For example, in one column I have:

'Company'. In the next column, I want to have it set up so that if the cell for 'Company' = A, then there is a drop down from Column 'Locations' in Table A.

B, for B, etc.

Little help?

Answer 1

First, It is not recommended that you do lookups on the table level. This can cause more problems then its worth.  All lookups should be done using list controls on a form.

Second, what you are referring to can only be done on a form. You would set the RowSource of your combo to look like:

SELECT CompanyID, CompanyName

FROM tblCompany

WHERE CompanyName LIKE Forms!formname!textboxname & "*;"

So whatever letter you type in the textbox, will filter the list of companys.