In the prime data table I have used the put the price field from the price table into the prime table directly.
Could you elaborate on this? If you mean that you put the field from the price table on the layout for Prime, then try making the field larger.
Yes, I put the price field on the price table on the prime table. But making the field bigger or the value smaller does not solve the problem. The really mysterious thing is that it only happens on some records.
What do you see when the value from the matching related record is missing? If you see a ?, the field may be too narrow to display the entire number as Mr. Vodka has suggested. If you see a blank space, I'd examine the key value of the two records that are supposed to be related to see if there is some character in the field for one record that is not in the other.
Well I changed the stock symbol field size and fixed the problem. Thanks !!!!!
For the Filemaker people this would seem to be a glitch in the program. There ought to be some way to indicate an inadequate field size that is more direct than just not working.