Jump to content
Sign in to follow this  
hexxabubba

Lovely Portal, Crappy Relationship!

Recommended Posts

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!

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

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:
    3DSteve 
×

Important Information

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