Results 1 to 1 of 1

Thread: Filter a Lookup

  1. #1
    Join Date
    Apr 2004

    Unanswered: Filter a Lookup

    In the database I'm making, I have a table called TASKS. The thing is that each task can have many related tasks. For example, if you perform one task "Tune Up Engine", then it is assumed that other tasks have been performed (Change Air filter, Change Spark Plugs, Etc.). What I did was create another table called RELATIONS with a lookup field called TasksRelatedCode. It looks back into the TASKS table and puts the TASKS table primary key in this field. My problem is that the lookup displays tasks from every BOOK. I want the lookup to display only TASKS from the BOOK I am currently working with. How do I query or filter this lookup?
    Attached Thumbnails Attached Thumbnails relations.png  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts