Hi Folks,
I have a field in Table A which uses "Type Ahead" to show entries from a related field in table B ...
All works great..
The problem is, I would like to get the Type Ahead to also work for the entries in the current field .. as the users sometimes put values in it that are not listed in the related field ...
Is there any way I can get Type ahead to work for both ?
Cheers
Dermot
Probably.
We would need to see how you have your type ahead feature set up.
Triggers/scripts/etc...
If filtering values listed in a portal, you might set up two portals filtered by the same text field and place those portals side by side or one above the other.
Hi Guys,
I simply used the "Auto-Complete using value list" option in the inspector and defined it based on the values from the Architect List in a related table ... see screenshot.
The issue I have is obviously that I would like to also get Auto-Complete working on the local values of the active field too .. (there are values manually entered in the local field which do not come from the related fields value list)
If there is a better way to do this which would work on the values of both fields it would be great ?
The problem is that you can't have a value list draw values from two different tables, thus this won't work. You'll need to consider other approaches--such as not allowing data to be in the local table without being also in the table on which you have based your value list. Another option might be some sort of scheduled script that regularly updates a third table with values from the other two and using that as your value list here.
Its a pity there's no better/easier way to do this ..
But saying that, thats not a bad idea Phil .....
"Another option might be some sort of scheduled script that regularly updates a third table with values from the other two and using that as your value list here."
I'll give it a go cheers
Thanks
Dermot
And since the third table need only store unique values, you might leverage a "create" enabled relationship to do this:
If you have this relationship:
Table1::ValueField = TableOfValues::ValueField with "allow creation" enabled for TableOfValues,
Set Field [ TableOfValues::ValueField ; Table1::ValueField ]
Will create a new record in TableOfValues if a record with a matching value does not exist, but there is no change to the table if it does.
Yes very good .. that should work really well..
Thanks Phil !!
Cheers
Dermot
There is more than one way to get "type ahead" to work. What method have you used?
And is this just a field formatted with a drop down list?, the filter field for a portal? or ???
The fact that the data resides in two different tables will make this a challenge.