Fields in related tables

[RSpisketts]

Howdy,

I want to show a custom dialog with a message that resides in a table in another DB file. So, I have set up a related ID field in the current table matching the ID in the other file.

By setting it to a particular value, I can access particular text.

However, problems arise when I move to another layout - I need another related "ID" field in my new current table. AND SO ON, AD INFINITUM.

Is there no easy way of getting at fields in tables in other files, without resorting to specifying related fields in the CURRENT TABLE ?

ie. Perhaps a global field in a not so current table ?

(tried this but didn't appear to work)

This post is re-worded from an earlier post.

Thanks.

Roger Spisketts.

[The Shadow]

You could make your messages into a global repeating field, then access them with:

gMessages::Text[ relatedID ]

from your Show Custom Dialog no matter what layout you were on.

[RSpisketts]

Thanks. I will try this.

[RSpisketts]

The Shadow - I just tried it. I set the text field to Global repeating (and put an arbitrary 1000 in as repeating number) and when I changed the text in one record, they all changed - am I missing the point ?

[The Shadow]

I was thinking you would have a string of text in each repetition, so you wouldn't have a table of strings, just a single global field.

Since its global, you can then access it from anywhere with no relationship.

See the attachment for a simple example.