I knew how to get it working in a form.
Thank you.
dnorris
Last Activity: Mar 23 '09, 05:33 AM
Joined: Mar 17 '09
Location:
-
Lookup Tab in Table Design
It the table design view, there is a 'lookup' tab for each field that allow a listbox to display the rows from a table or query.
When a user is entering/editing a row in Teams, they first choose Dept_ID from a listbox of all rows in Departments (I have that working). Then then choose Group_ID from a listbox of all rows in Groups where Groups.Dept_ID equals the value of Dept_ID in the current...Leave a comment:
-
Du'h
I meant the Teams tableLeave a comment:
-
Amplification
In the table Names, I first do a look up for Dept_ID using all the available records in the table Department, then I want I do a look up for Group_ID where I limit the rows displayed from the table Groups where Groups.Dept_ID equals the value Dept_ID for the row I am currently entering.
I can do this in a form, but I would like to build this into the design for the Table Names.Leave a comment:
-
2 Level lookup in a table
Hi,
I am baffled on this one and perhaps just a bit brain dead. I have a table with two look up columns.
Structure
Departments
Dept_ID Autonum
Dept_Name Text
Groups
Group_ID Autonum
Dept_ID Num
Group_Name Text
Teams
Team_ID Autonum
Dept_ID Num
Group_ID Num
Team_Name Text
In a table=based look up for Group_ID in the...
No activity results to display
Leave a comment: