Lovely Portal, Crappy Relationship!

[hexxabubba]

Thanks in Advance to all you Filemaker Gurus! This is a film rights db. I have an awesome portal setup with Territory & Film Type. WORKS GREAT!

I need the Title field in Titles to be related to the Title field in avils, and Title:film_type needs to be the category filter instead of Avails::film_type..I can't make the relationship work and I've tried it every way!

I hope someone can help me! Enjoy the lovely portal!

[Søren Dyhr]

Perhaps you mean this way??

--sd

Film_RightsSD.zip

[hexxabubba]

Looks good, But I found a problem with the Fiml_type (category) filter. For example, I changed the Titles::Film_type (browse mode) on the record for Pearl Jam to "documentary" and it didn't change in the portal. Check it out!

Once again, thanks for all your help!

[Søren Dyhr]

Sorry for not thinking straight, try this instead!

--sd

Film_RightsSDmod.zip

[hexxabubba]

Thanks so much! This is getting close to the point where we have a cigar!

It seems that the merge field <> that"s on top of g_territory does not change, stays on current record making it appear as if the portal is displaying the same territory.

Also, when you type in Territory_id in avails shouldn't the territory autmatically populate. And should I be creating a new territory from Avails, when there is not one. Also, when you put a name in avails::title it creates a new record in title every time. There is 1 title to many avails...

The way it was set up before, I had the territory sort of hardwired and there was only 1 record. It is not imperative to keep track of territories.

Once again, thanks so much for your help!

[Søren Dyhr]

It seems that the merge field <> ; that"s on top of g_territory does not change, stays on current record making it appear as if the portal is displaying the same territory.

That's an omission on my behalf, I have made a relation for it - make the mergefield show that instead.

I can easily fix these 3-4 matters, can you??

--sd

[hexxabubba]

Thanks Soren,

I can easily fix these 3-4 matters, can you??

I have tried and failed...Can you help me with these matters...

Thanks

[Søren Dyhr]

Sorry for keeping you in suspence, a holiday made me loose focus, and I admittedly forgot everything about it.

:oops:

But anyways take a look at the changes I've made, is this what you had in mind? Or are there more open issues??

--sd

Film_RightsSD2mod.fp7.zip