Jump to content

partial string relationships


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

Recommended Posts

I have a portal from a media library database. The media library has a field that notes which project each tape in the library belings to. There is also a project database, in which there is a portal that lists all of the tapes from the media library that are for each particular project and is related by the library's project number field and the project detail's current project number. This works fine for tapes that have only one project number in the project field, but for tapes with, for example, "1001, 1002" in the project field, the tape will not be displayed in those project's portals. Is there a way to get them to be listed, possibly by looking for a partial string match? Thank you for any help.

Link to comment
Share on other sites

quote:

Originally posted by [email protected]:

I have a portal from a media library database. The media library has a field that notes which project each tape in the library belings to. There is also a project database, in which there is a portal that lists all of the tapes from the media library that are for each particular project and is related by the library's project number field and the project detail's current project number. This works fine for tapes that have only one project number in the project field, but for tapes with, for example, "1001, 1002" in the project field, the tape will not be displayed in those project's portals. Is there a way to get them to be listed, possibly by looking for a partial string match? Thank you for any help.

What you can do is to reformat your ProjectID field into what is known as a multi-key. Instead of seperating the projectIDs with a comma, seperate them with a carriage return.

When Filemaker evaluates the relationship, it will look at each line of the keys for matching values.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=

Link to comment
Share on other sites

This topic is 8548 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
×
×
  • Create New...

Important Information

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