Previously I had an issue with Conditional Value Lists. Thanks to the community and philmodjunk's very useful Adventures 1 file, I was able to resolve the issue and get my hardwired CVL working.
Unfortunately I'm back with more CVL Issues. I think this time I need a basic CVL, but I'm not sure what I'm doing wrong.
The goal is to have a CVL that filters Machine Serial Numbers. So first I will provide the context. Each Project may contain several machines, which are each tracked with a serial number given by the supplier. Thus there is a Machines table linked to Projects via kp/kf fields. The auto enter Project Number from Projects, automatically gets assigned to a machine via a lookup field in the machines table.
This works fine. The issue then comes when trying to assign after sales to the machine. The way it works is there is either Legacy or S3 Process (Legacy being Pre-S3 Projects and thus irrelevant).
If S3 is selected, it then shows a dropdown with all projects, and if a project is selected with an associated machine, I am trying to get it to display only machines relating to that project (Please note the project in the example DOES have a related machine.
Instead of displaying the Serial number I get the following.
Please see captioned screenshots below which demonstrate the setup if the current items.
List linked with the serial number dropdown (Seen above).
Serial number dropdown field data source.
CVL Link and table occurrence.
Relationship for data source and values for CVL.
Relationship for data source and display values.
I'm sure it's probably blatant and people are screaming at their screens reading this. If you could let me know some advice as to what I need to do, please let me know. Many thanks.