Drop Downs

[Saddletramp]

I have been using a dropdown list. All of a sudden it stopped dropping down. I went in to check it, and the message "This value list will not work because the field "ID code" cannot be indexed". What could change to create the inability to be indexed when it was before.

Thanks

The Tramp

[comment]

What could change to create the inability to be indexed when it was before.

Most likely, the question is "who", not "what". Unless your file has become corrupted, things don't happen "all of a sudden".

[Saddletramp]

I know things don't just happen... But, I still need a lead on where to go to solve the problem. I am Totaly lost. Should I duplocate the table and delete files untill it indexes? SO I can find out which file is causing the trouble. That is my only ides right now.

Thanks

The Tramp

[comment]

The lead is to go the table where the ID code field is defined, and check how it's defined. Given the discussion here:

http://www.fmforums.com/forum/showtopic.php?tid/194785/

I would guess that's where the problem is.

[Saddletramp]

The lead is to go the table where the ID code field is defined, and check how it's defined. Given the discussion here:

http://www.fmforums.com/forum/showtopic.php?tid/194785/

I would guess that's where the problem is.

The Id code I am refering to now, Is the code that started that discussion on using real names. The code I am using is working fine. That IDcode is a asimilation of generated codes as you know, The code that is causing the problem is an asimilation of abriveated real names and numbers. WWhich in this case you are probable correct in your assumption. But other then duplicates I don't know what to look for. I looked for dups. and can't find any.

Thanks

The Tramp

Edited May 7, 2008 by Guest

[comment]

If, as I suspect, you have changed the ID code to be an unstored calculation field, then it cannot be indexed. I wouldn't call this "working fine". In the other thread, I suggested you use auto-entered serial numbers as your primary keys. I repeat that suggestion here.

[Saddletramp]

If, as I suspect, you have changed the ID code to be an unstored calculation field, then it cannot be indexed. I wouldn't call this "working fine". In the other thread, I suggested you use auto-entered serial numbers as your primary keys. I repeat that suggestion here.

I am using auto-entered serial numbers as my primary keys. I just use a calcuclation to put them togeather. Anyway, I found an unusual link, I have seen it here before but can't remember where so I can't find it, and I can't remember what it means. At the end you have one line One to one Or three lines (Crows feet) One to many This one is two vertical lines Kind of like a vertical earth ground symble. The link had been made that link with the "name" code rather then the "Number code" I reestablished the "Number Code" link and went to a one to many, As needed. This allowed the list from the table to be indexed to a dropdown in a layout.

Thanks

The Tramp

Edited May 7, 2008 by Guest

[Saddletramp]

It worked Then it didn't I back in the same hole.

I was using an untored calculated field then I went to a stored but it still doesn't index. The Calculated unstored field I use for the "Contiversial" Numeric Code is indexed and it works but when I try to combine the "name code" that the operator can visually identify with in the second field of the dropdown lis, that is when I have the problem.

The Tramp

Edited May 7, 2008 by Guest

[comment]

The Calculated unstored field I use for the "Contiversial" Numeric Code is indexed

No, it is not. It's not possible for an unstored field to be indexed.

I have a feeling this is heading towards repeating the previous thread all over again, and I am not interested in that.

[Saddletramp]

Don't worry about it it won't repeat. I concead I am starting the DBS all over again. You were right. I have seen the wicked ways of my path, and will change. Thank you for your direction, and patients. I am learning FM is not at all like Access. Or I have just been away from it all too long.

Thanks and I am sorry

The Tramp

Edited May 8, 2008 by Guest