This is something I'm totally new to, creating a table using partial data from an already present table.
What I want to do (don't have this established yet) is use a table that will hold data on personnel and take from that table only the persons name.
Using the information from that table, I'm wanting to include that information in a totally different table with information on job evaluations and other items.
Here's where I get real fuzzy. I'm wanting to combine these two tables in a query, which will be where a new form will get that information.
I know I need to establish a relationship, but I'm not sure which table needs to hold the primary relationship.
Any help is appreciated!
What I want to do (don't have this established yet) is use a table that will hold data on personnel and take from that table only the persons name.
Using the information from that table, I'm wanting to include that information in a totally different table with information on job evaluations and other items.
Here's where I get real fuzzy. I'm wanting to combine these two tables in a query, which will be where a new form will get that information.
I know I need to establish a relationship, but I'm not sure which table needs to hold the primary relationship.
Any help is appreciated!
