Hi, I need help on my DB, I have two portal ( first his Projet and second his Phase). I want to select (on one click) a row in the first portal and have apear the related record in the second. Can you help me on this....I came from ''access'' and I'm new too Filemaker and I realy love it!

I'hope it's write correctly because I'am not bilingual...sorry.

Edited February 13, 200718 yr by Guest

You can have it so that when you click on the record in the first portal, it sets a global field with the key recordID and then the relationship for the second portal would be based off from the global field to the related table.

IOW, create a new relationship with your key fields being the global field and the foreign key of your related table. Then reference that relationship for the portal.

Tank you very much for the guide line, but if you have a like or an exemple with two portal is gone a help me too understand it and very appreciate...

Thanks

Steeve

It's me again, I have difficulty to extract the Project_ID who is show in the protal row. I check the ''Viewer table'' on your site, but it's don't help me to extract the Project_ID

Merci

Steeve

Like this

ProjectPhase.zip

I have too quit, but I check it rapidely and it's work very good and I want that in my DB. But I try it before and it's don't work. I'm gone a check my relationship based on your.

Thank you very very much

Steeve