Portal Searching and Filtering

[arbelbedak]

Hello,

I am setting up a licensing table/layout for my music processing and licensing database. Currently, the flow of information runs like so:

Music Owners > Scores > Tracks > Edits

One Music Owner owns many Scores, and each score contains a number of Tracks. Each track may contain a number of Edits from that track.

I am now creating a licensing table and layout and I need to create a portal that displays tracks as typed into the search field above it (see attached image). I want to be able to type in part of a track title and have it display all of the Track titles that contain the word(s) typed into the Search field. I've been trying different thing, using variables and global fields, but I feel like there is something I am missing.

The portal will display the fields Track Titles and Score Titles from the related Tracks table.

I will then be setting it up so that when you click on a track title it will populate the related track's information into the licensing form.

Thank you for your help. Let me know if you need more details to help me out.

Arbel

[efen]

The 2nd file that's attached to this post

http://fmforums.com/forum/topic/83582-display-all-info-upon-selecting-a-record-from-a-list-all-in-one-layout/

has a portal that does that.

In the file change the 1 in the portal filter calculation to "" so that nothing shows in the portal before you start entering letters.

[arbelbedak]

I am a little confused. Will this work the same way for two separate tables? The example you posted used a second occurrence of the same table.

Thanks for your help!

Never mind, I figured it out and it works. Thanks for your help!