Jump to content

Using autocomplete over a relationship ?


R2D2
 Share

This topic is 5661 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 5661 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.