table proporties populating

[Jen0dorf]

Hi



been having various issues with a database and was searching for reasons as to why is was unstable -or appeared to be so.

Whilst trawling through the various forms tables etc I discovered that if I went into table design on the right hand side a window with table proporties was visible,

I have never used this function - indeed I did not even know of it's existance

IN the properties are the following:

filter

([tblDeceased].[YearOfDeath] In ("1939","194?","1971,03","1975,09","1997C1","69","969","Tc1670"))

sortby

[tblDeceased].[Mlink]

I have never inserted this code And it seems to be rubbish.

Is there anyway this can self populate? or do I assume it's just a gremlin?

thanks

Ian

[orange]

How do you define YearOfDeath?

[Jen0dorf]

Hi
YearOfDeath is defined as shorttext

thanks

Ian