using a cartisian relationship as a global

[Aussie John]

I have two tables (Table 1 and Table 2) that need to be related . The match field in Table 1 is a concatenated calculation which uses a field from a third table (Table 3) which is linked to Table 1 with a cartesian relationship. Table3 xxxxxxx Table1 ===== Table2.

Table 3 is a single record field so the field mimics a global, but one which is common to all users. The relationship T1 to T2 fails as it cant unstore the T3 field. Is there another way to do this?

[nesor]

Can you post a sample file?

[Aussie John]

Can you post a sample file?

Sure - the relationship works in one direction only.