Using autocomplete over a relationship ?

[R2D2]

Hello again !

Is it possible to use an autocomplete function via relationship ? I have one table that is used to select a person. A person id-number is a key field to person database. I wanted to keep it simple and have just one field to fill in id and below that a portal which shows matching names when id is written. It would be cool if the portal is filled when just writing the first numbers of the id and then you could select the correct person.

Thanks in advance again

Arttu

[Razumovsky]

Hi Arttu,

Yes, it is completely possible.

You can Auto-type based on values from a value list. So, all you need to do is create a value list of Person ID numbers.

Keep in mind that you can also set a value list to display values from a different field than it returns (for example, you could have the value list show the Person Name, but return the Person ID to the field).

HTH

-Raz

[Søren Dyhr]

Shouldn't we see a template doing this? Autocomplete will only bring in previously entered values from the field in the remaining records?

--sd

[Razumovsky]

If you specify the field to display as a value list, FM8 allows you to also auto-type based on that value list and choose to hide/show the list with the other checkboxes in the field setup dialog.

It should be pretty straightforward if you give it a shot. Quite a handy new feature.

[Søren Dyhr]

Indeed!!! When observing the restraints in deployment, that is the fields needs to be text and not number and the entry method should be drop-down:

http://www.filemaker.com/help/24-Editing%20objects23.html

...so ID-number actually is ID-number-string!

--sd

[R2D2]

Hi !

Thank you for this advice. There is just one problem. Auto-complete is not supported in drop-down lists when the value list used is configured to use Also display values from second field, Show values only from second field, or Sort by second field.

Any ideas ?

Arttu

[Razumovsky]

Hmm, yes, was just noticing that myself. There are at least 2 ways you could get around this by adding a PersonName field in your record that would have the autotype value list of just PersonNames from your person file. Then:

1).

-Create a = relationship from Record::PersonName to Persons::Name

-Set PersonID in your record to be a lookup from PersonName::PersonID

OR

2).

-Create a value list that has PersonName on the left and personID on the right.

-Set Person Id as an AutoEnter (Un check Do not replace) to select the right word from the value on the list that matches PersonName.

HTH

[R2D2]

Hmmhh... Ok... I have try these.

Thanks !

Arttu