I've put a date field from a different table onto a layout and it has a <unrelated> message in the dialogue. However, the tables are definitely related. What might be the problem?
Post a screenshot of the relationship graph.
The Front::Date seems not related to any of the other tables.
BTW: it must be seen by all the other tables if it is a global field.
I'm using 'Front' as a Home 'Table of contents' with link buttons to other layouts so at the moment it doesn't need to be related.
The unrelated field is 'Prescribe::Date modified' on Record and since there's a relationship between Prescribe and Record I'd have thought it was related.
On which of these table occurrence "boxes" is your layout based?
If Layout Setup | "Show Records From" lists "Front", then NONE of your fields except Front::Date will be related when place on that layout. Relationships evaluate from the occurrence specified in that drop down.
Retrieving data ...