I am new to Microsoft Access 2007. I am creating a form and I want to use a list that is created from data in a table. Here is what I have.
2 Tables: Projects and Task.
The tables are related by the projects.
In the task table I want to select the project using a drop down list that is created by a query of the Projects table. Therefore the user can assign a task to an existing project.