Jump to content

Relationship Help


mark s reynard
 Share

This topic is 4338 days old. Please don't post here. Open a new topic instead.

Recommended Posts

HI please see attached file.

I have 3 tables 1 that stores users, 1 that stores books, and 1 that stores books read.

What i am trying to achieve

In the Users layout i want to show a portal showing all available books from the books table, but i want to highlight using conditonal formatting all the books read by the user.

Please help as i am seriously stuck on this

Thanks

mark

test.fp7.zip

Link to comment
Share on other sites

Hi thanks for all your help on this, i'm really grateful, however, these solutions don't address my original dilemma.

I was wanting to show 1 portal showing all the books available, then by using a calculation field if the book had been read by this user, bring the read date from the books read table.

I was then going to use conditional formatting to highlight any of the books that has been read.

User Mark Reynard

Books Available Read Date

Filemaker 10 Beginners 24/01/2011

Filemaker 11 Beginners 25/01/2011

Filemaker 11 Server

User Dan Hepworth

Filemaker 10 Beginners 01/10/2010

Filemaker 11 beginners

Filemaker 11 Server 24/03/2011

I hope this makes sense. I know they'll be a way to do it, just cant get my head around it, Thanks again for all your help.

mark

Link to comment
Share on other sites

I was wanting to show 1 portal showing all the books available, then by using a calculation field if the book had been read by this user, bring the read date from the books read table.

I was then going to use conditional formatting to highlight any of the books that has been read.

It is quite easy to highlight the books read by the current user. It is not so easy to include the date read in the AllBooks portal. The date read is not an attribute of a book - the same book has different dates read, by different users. The book record does not know which user record you are currently viewing.

The solution for this is to have a global field in the Books table indicating the currently viewed user record (populated by a script triggered OnRecordLoad in the Users layout). Then you can have a relationship between AllBooks and BooksRread matching on BOTH BookID and gUserID and place the date read from the matching record in the portal.

Link to comment
Share on other sites

Hi, could you explain the easy method to highlight the books read by the current user, as this is effectively all i need to achieve.

And that already exists in the example I posted.

Link to comment
Share on other sites

This topic is 4338 days old. Please don't post here. Open a new topic instead.

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
 Share

×
×
  • Create New...

Important Information

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