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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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