scan check

[happydermis]

Hi all,____I was trying to add a relation to my report but I couldn^t get anything out of that table. Doesn^t matter how I tried to link the table to my base table - nothing helped. Now I added a scan check (IIF(SCAN(MACHINE),"was scanned", "wasn^t scanned") - still I get nothing - I was hoping that I would get an indication if the table is being scanned at all but instead I don^t get a thing - only a blank space. ____Any ideas why such thing is happening??____Many thanks, Dekers__

[kfleming]

If you are not getting information from a related table, it indicates that the relation is not set correctly. In the Xbase version you want to make sure that the linking field matches the index key expression of the related table. And if the linking field only matches the first part of the index key, you need use the partial match checkbox and set a character match length.____Kathleen__R&R Support

[happydermis]

Thanks Kathleen,____the problem was my index. the table I wanted to link uses UPPER() for its key so I used UPPER() when I tried to link it. For some strange reason it would go through but wouldn^t not give me any information from the linked table.__Now I am using the key without the UPPER() function and it works nicely.__I don^t really get it - I must admit.____Thanks, Dekers__