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?

[Webinar] Streamline your web hosting managementRegister Today

x
 
als315Connect With a Mentor Commented:
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
All Courses

From novice to tech pro — start learning today.