Jump to content
Sign in to follow this  

show related from a global field

Recommended Posts

I am trying to use a portal to so me related records from a table as I type into a global field. Example if I type 'Da' in he global field i'll get all the records from my user table that have a name of Davis, Dali, Dance....

Table 1 is Users

has a field for ID, First name and Last Name (other fields too but not important here.)

I have another table lets call it User Logs their main are relation is via the ID field.

I've tried making additional tables and relating the global field to the ID number and many combination of that but i just cant seem to get it working.

Any suggestion to get this working would be greatly appreciated.

Share this post

Link to post
Share on other sites

For the relationship to match, the global text field in the local table where you enter a partial name must match something in the related table. This can be done with a multi-key match field, but these are most easily made with a custom function (you need the Developer version to add a custom function to your solution.) Another method uses the new range relationship operators (<,>,<=,>=) to show related records whose key is greater than or equal to the text in your global. I'll see if I can dig up an example of this technique.

This by itself does not give you results "as you type" (a method referred to a clairvoyance.) Typically, the parent key field must be exited before a portal updates. I think Cobalt Sky has a demo of clairvoyance that's a little more refined. There are also plugins that can do some of this.

Share this post

Link to post
Share on other sites

You can find an example of the range relationship for your portal on databasepros.com. In the Resource section, do a search for "Type Ahead". Take a look at the FM7 version.

Share this post

Link to post
Share on other sites

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
Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:

Important Information

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