I know this should be easy but for some reason I keep messing it up!
My scenario:
Two tables - Quotes and RAMS both with a single row per record. A Quote would usually be associated with only one RAMS .... but occasionally there might be two or three.
A Quote is created first and has, amongst other fields a Quote No. field that is Text - this is unique to each row:
The Quotes table also has the virtual Related RAMSs field:
The RAMS table also has a Quote No. field which is a Ref with the Quotes table as the source:
If I create a RAMS row with the same Quote No. as a row in the Quotes table - why does the Related RAMSs field stay empty?
User | Count |
---|---|
14 | |
11 | |
9 | |
7 | |
4 |