Hi all

I have been trying to do a clairvoyance portal for our national broad number. The problem is when i try to do the selfjoin relationship on "Keywordc" and "Matchcalc", Filemaker says that "Matchcalc" cannot be index and that the ralationship will not work. Would someone look at the attached files and please tell me what i have done wrong.

Thanks

Lionel

typeahead.zip

matchcalc references related fields and therefore can't be indexed. I think you are trying to display records from nationaldb anyway. Define matchcalc in nationaldb and rebuild your relationship from keywordenrtyc to matchcalc.

Hi Robert

Thanks for the insight but it did not work, Only the first record number is displayed and i cannot get it to accept a new typed in number.

Lionel

Hi Robert

I am soory for the quick reply. It did work but not the way i was hopeing it would. I would like to show all the records and goto the record as i am typing in the number.

Thanks

Lionel

Hi all

Got it to work

Thanks