How do I get these fields to display data in the report?

In this sample database, I have tables for Issues, Defects_DCRs and RFCs. The Issue table holds the main issue and the Defects_DCRs and RFCs tables hold stages of the issue as it is being tracked in other databases in the department. From the Defects_DCRs table, I need to display the DCR_Descrption associated with the issue. From the RFCs table, I need to display the Summary associated with the issue. Some main issues have a DCR_Defect, some have an RFC, some have both.
RFCsTest.accdb
LVL 1
David BigelowStaff Operations SpecialistAsked:
Who is Participating?
 
als315Commented:
Your tables are joined to ID fields. and it is correct, but in main table are stored values and not stored IDs. You can change join (look at sample), but will be better to store reference to ID in main table.
RFCsTest.accdb
1
 
David BigelowStaff Operations SpecialistAuthor Commented:
Thank you. It's been a little while and I'm getting a bit rusty.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.