platypusfeet
New member
- Local time
- Today, 06:38
- Joined
- Nov 14, 2018
- Messages
- 8
Hi - I apologize that this is a very basic question that has already been answered, but I cannot find the answer anywhere. I am new to Access and need a bit of a play-by-play for this particular question in order to start really making progress.
I have a table full of "risk items". Each "item" can belong to a number of categories. For example, each "item" can apply to a specific "project".
So I have my "risk items" table that I want to add new records to. I also have a table for projects with "project name" and a unique project key ID. In the risk items table, I have a column for the project key ID (and I've already established the one-to-many relationship).
I want to use a form with a combo-box to specify which project the item applies to. I only want to be able to choose projects that are already included in the project table (so the project table will not be edited). I want to be able to choose the project name from the drop down and then have the form save the corresponding project key ID to the risk item table.
So my two tables are:
RISK ITEMS
- Project ID (number) [one-to-many relationship]
- Item Information (string)
PROJECTS
- Project Key ID (number) [one-to-many relationship]
- Project Name (string)
In my form I want to be able to see and choose from a list of Project Names (string; PROJECTS TABLE) to add the corresponding Project Key ID (number; PROJECTS TABLE) to the Project ID column (number; RISK ITEMS TABLE).
I know that I need to use a query, but I can't figure it out. Thank you in advance!
I have a table full of "risk items". Each "item" can belong to a number of categories. For example, each "item" can apply to a specific "project".
So I have my "risk items" table that I want to add new records to. I also have a table for projects with "project name" and a unique project key ID. In the risk items table, I have a column for the project key ID (and I've already established the one-to-many relationship).
I want to use a form with a combo-box to specify which project the item applies to. I only want to be able to choose projects that are already included in the project table (so the project table will not be edited). I want to be able to choose the project name from the drop down and then have the form save the corresponding project key ID to the risk item table.
So my two tables are:
RISK ITEMS
- Project ID (number) [one-to-many relationship]
- Item Information (string)
PROJECTS
- Project Key ID (number) [one-to-many relationship]
- Project Name (string)
In my form I want to be able to see and choose from a list of Project Names (string; PROJECTS TABLE) to add the corresponding Project Key ID (number; PROJECTS TABLE) to the Project ID column (number; RISK ITEMS TABLE).
I know that I need to use a query, but I can't figure it out. Thank you in advance!