I need help with a drop down from table but in a related table (If this makes Sense)

[Tom Arnold-Hames]

Hello Everyone

I really hope someone can help me here because I am ripping my hair out lol. I have a tables called "Customers" related to that table is "Customer Machines", this shows all the different types of machine that customer has.... all great and all working. However my client needs to create individual Risk assessment reports for different machines, So related to the customers, is a risk assessment table, With a bit of scripting this writes basic information about all the different Risk Assessments related to the customer, from there The individual risk assessments tables. What I want to do is be able to use a drop down that shows the customers machines in the individual Risk assessment tables. Now I have created the drop down, and it works, however its bringing in ALL machines from ALL the customers I only want it to bring in the machines related to the customer that the risk assessment is for.... 

I have attached a picture so you can see my relationships, but any help would be great... I appreciate this so much

 

[comment]

When you define a value list you have the option to include only related values:

In your example, you will want the value list to use values from the Machine_ID field in the Customers Machines table, include only related values starting from Customers.

And you will also want to add another occurrence of the Customers Machines table to the graph and connect it to the RA Table directly by matching Machine_ID, so that you can access the data from the selected machine in the report (there should be no need to have fields that describe the selected machine in the RA Table itself).