Related fields showing strange values

[JariV]

Hi,

I've created a separate related DB to hold field titles (text labels) for various language versions. The match field (number, indexed) in the master file contains value 0,1,2 or 3. The related file has 4 records each containing one of these values in the match field.

The field titles work properly, when the value in the match field is 0,2 or 3 (eg. show the correct corresponding value from the related file), but when the value in the main file's match field is 1, then all the related fields in the master file also show just "1". (instead of the values in related file's record holding 1 in the match field).

Any ideas why this is happening?

Jari V

[LaRetta]

Hi Jari,

Is the field (displaying the 1 when it should be displaying the language version) the exact same field that displays the language versions for 0, 2 and 3 or is it on another layout? If so, double-click the field (in layout mode) and make sure you haven't pasted the join field instead of the language version field there.

If this is correct and it properly displays the language version (in the same field) for the others but a 1 for your second language, then your relationship is correct and your data is probably wrong. Check your related data on a table layout from your related file and see if there is a l in the language version in addition to a 1 in the match field.

If neither of those ideas solve your problem, you have something else going on you haven't yet explained to us. We'll help you figure it out!

LaRetta

[JariV]

Thanks LaRetta,

I checked the points you mentioned, but couldn't find anything wrong there.

However, since the database for language labels was still quite simple, I just recreated the file from scratch - that solved the problem.

You were probably right saying there was something else going on - for a newbie it's often difficult to pinpoint problems beyond the most obvious...

Thanks again,

Jari V