Add a where clause to expression builder - Easy fix?
Posted on 2008-10-30
This should be a quick fix - but access is driving me nuts.
In the simplest of terms: I have a two tables, A and B. When a user clicks a particular field in table A, they are passed through to table B. Table B contains a field called "NameField" which relates to a username. The ID of this user is also passed to table B, and this appears in the NameField.
What I want to do, is run an epxression within the NameField similar to:
NameField = select username from users where userID = tableB.NameField....
Easy right? I've tried creating macros, expressions, yadda yadda, and nothing. This baffles me as it is the corner-stone of all forms: passing ID's and then looking up the rest of the info based on the ID.