Help me resolve my terrible relationship with Ref columns ๐Ÿ˜ฉ

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:
TedM_0-1741635129281.png

The Quotes table also has the virtual Related RAMSs field:

TedM_2-1741635494064.png

 

The RAMS table also has a Quote No. field which is a Ref with the Quotes table as the source:

TedM_1-1741635230901.png

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?

 

0 3 79
3 REPLIES 3
Top Labels in this Space