If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Lookup Table
I have three tables:
Requests: Stores data about maintenance requests Categories: List of maintenance categories (i.e. mold, plumbing, etc.) AssignedTo: List of people who maintenance requests can be assigned to Each request has a category, and each person in AssignedTo has a category. The requests table contains a field for AssignedTo. I'm trying to set up a lookup so that once a category is selected in the Requests table, only AssignedTo's with the same category as the category of the request itself will show up on the list. I tried to do some queries, but I can't figure out a way to reference the current record in a query. Any thoughts? |
#2
|
|||
|
|||
Lookup Table
Are you using a form? If so reference it as Me.Control where Control = the
name of the dropdown box for Requests. Truthfully, the best way is to use cascading comboboxes: http://www.fontstuff.com/access/acctut10.htm -- hth, SusanV wrote in message ups.com... I have three tables: Requests: Stores data about maintenance requests Categories: List of maintenance categories (i.e. mold, plumbing, etc.) AssignedTo: List of people who maintenance requests can be assigned to Each request has a category, and each person in AssignedTo has a category. The requests table contains a field for AssignedTo. I'm trying to set up a lookup so that once a category is selected in the Requests table, only AssignedTo's with the same category as the category of the request itself will show up on the list. I tried to do some queries, but I can't figure out a way to reference the current record in a query. Any thoughts? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Add New Field to DB | Karen | Database Design | 7 | October 19th, 2005 08:03 PM |
Help with relationship plase | Rock | General Discussion | 5 | July 4th, 2005 03:54 AM |
Seeking some expert advice. | HD87glide | Using Forms | 14 | March 23rd, 2005 10:11 PM |
Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. | HDW | Database Design | 3 | October 16th, 2004 03:42 AM |
Make a field lookup dependent on the value in another field of a record? | Susan A | Database Design | 8 | May 22nd, 2004 09:10 PM |