Create New Access Table from Primary Keys of two other tables

[iSRS]

Hello,

New (returning after years away and wasn't able to reset my password) here and couldn't find this anywhere, so figured I'd start this thread.

I am working on an Access 2010 database I created. I am looking to do the following.

Create a table from the primary keys from two different tables, along with some other info that would be unique to the key+key combo

Tables I have:
tbl_Resources
[PK]ID (AutoNumber)
First (Text)
Last (Text)
Role (Text)
etc.

tbl_CouseList
[PK]Course Number (Text - this is because there are predefined course numbers that are 6 digits and could start with zero)
Course Name (Text)
Course Type (Text)
Required Course (Yes/No)

What I need:
A table that will take every Resource ID, and assign every Course Number for each Resource ID, and then add the Required Course from tbl_CouseList, then additional, new fields:
Status ({blank}, Complete, Scheduled, TBS)
Company Course (Yes/No - This is identifying if it was an internal course or third party/outside course)

Is this something that can be done? What are the steps?

Example:

[b]ID     CourseNumber     Required Course     Status        CompanyCourse[/b]
1      012345           -1                  Complete      -1
1      012346           -1                  Scheduled     -1
2      012345           -1                  Scheduled     -1
2      012346           -1                  Scheduled     -1

Thanks for your help, folks!

 

[SkipVought]

hi,

how about forum700

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]