File link warnings (ASAP)

[jenietcu]

Hi,

I got this errorr 'File link warning. The specified fields may not link successfully due to different lengths'.

What should I do with this error or any workaround regarding this error? What could be the cause of this error?

Thanks and Regard,
Jen

 

[FoxG]

Hi Jen,

You are trying to link two field which have a different structure on the database.

It is normally because you are linking tables on a field that is not the common key field.

If this is text then you should get away with it, as the link should find a corresponding record on the second table. You may either get duplicates or never find fields where they are longer than the length of your first table.

Geoff

 

[databaseman]

As long as you are sure that the data in the fields does match and that one table doesn't include spaces you should be ok linking them anyway. I'd recommend doing a test report linking those fields and running a SQL (or whatever) query seperately to check that all expected data is returned in CR. If there are no anomalies between the query and the report, go for it!

Databaseman Database Man
Defender of Life, Liberty and the pursuit of accurate database reporting! Follow my free tek-tip adventures at:

http://www.hammerman.com/dbman.html