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. (Originally posted in a more generic forum)
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:
Thanks for your help, folks!
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. (Originally posted in a more generic forum)
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:
Code:
ID CourseNumber Required Course Status CompanyCourse
1 012345 -1 Complete -1
1 012346 -1 Scheduled -1
2 012345 -1 Scheduled -1
2 012346 -1 Scheduled -1