T
tgingrich
I feel kind of silly asking this question, but I'm kind of new to this.
I have a form that will be used by our HR department to enter new employee
informatiuon. It has an Access database table containing user information as
it's primary data source, and a table contining security access rights by
position title as it's secondary data source. After the user information is
submitted, the form is e-mailed to our security administrator. I want to have
him open the form in a different view that will contain the access rights for
the new employee's position.
To do this, I am trying to edit the SQL for the secondary data source to
contain a where clause so that the correct row in the Position table is
retrieved based on the position in the User table. In other words WHERE
Position_Table
osition = User_Tableosition.
The problem is, I don't know the correct SQL syntax to refer to the Position
field in the primary data source. Can anybody help me?
I have a form that will be used by our HR department to enter new employee
informatiuon. It has an Access database table containing user information as
it's primary data source, and a table contining security access rights by
position title as it's secondary data source. After the user information is
submitted, the form is e-mailed to our security administrator. I want to have
him open the form in a different view that will contain the access rights for
the new employee's position.
To do this, I am trying to edit the SQL for the secondary data source to
contain a where clause so that the correct row in the Position table is
retrieved based on the position in the User table. In other words WHERE
Position_Table
osition = User_Tableosition.The problem is, I don't know the correct SQL syntax to refer to the Position
field in the primary data source. Can anybody help me?