Nothing is showing up in my portal...

[Axedd]

I created a relationship between three tabs -- hopefully correctly -- and now I want to show two of the tables on the join table by using portals. Yet when I set it up, nothing appears? What am I doing wrong? 

[Lee Smith]

There a few reasons a relationship isn’t working as expected.

Check to see if the Key Fields are the same type (i.e. both are text, number, etc.)

That you have selected the right fields in the Relationship graph.

That you actually have child Records.

 

HTH

Lee

You can attach a copy of your files by following the steps found here. Attach a File

[Axedd]

I'm still not sure what went wrong, so I'm going to attach the file. 

Family.fmp12.zip

[doughemi]

Your relationships aren't quite correct.  Try this:

Family.fmp12.zip

[Lee Smith]

I agree with Doug,

 

I took the Contact file from the starter files for v12 and created a new file for you.

 

Understanding Relationships is a very important part of database design.

 

You should look at some references on Relationships. One that I think is easy to follow is the FileMaker Pro series by Lynda.com

 

 

HTH

 

Lee

Contacts.fmp12.zip

[Axedd]

Your relationships aren't quite correct.  Try this:

That doesn't look any different to the one that I attached?

 

Also, I did watch many, many of the FileMaker videos on Lynda. So I really thought that I would have been able to do this easily, but that turned out to not be the case.

[doughemi]

That doesn't look any different to the one that I attached?

It is significantly different. In your version, one child and one parent can have many families.  In mine, one family can have many children and many parents. The primary Family key is the foreign key for both Parents and Children.  Yours has the relationship reversed.

 

The foreign key field should be in the "many" side of a one-to-many relationship.

[Lee Smith]

Hi Axedd,

 

Because you said

 

That doesn't look any different to the one that I attached?

I was working on a Reply about why they are not alike, when Doug posted today. 

 

I looked at Doug’s file when he posted it, and figured he had nailed it. 

 

Even though he had post his file, I went ahead posted mine because, I had already invest the time to make it up in order to give you a different way of looking at your data using a Tab Panel.

 

However, if you look at the two relationship graphs (Doug’s and mine), you would have seen, we both used the same type of relationships 1 to Many between the Current Record to the Related Records.

 

Before Doug’s post of today, I had revised your original file in several ways. 

 

Following similar key field naming as lynda.com used, I modified your key fields as follows.

 

Family

FamilyID. renamed PK_FamilyID

 

fkChildID Not needed in this instance.

fkParentID Not needed in this instance.

 

Parent

ParentID Renamed FK_Family_ID

 

Children

ChildID  Renamed FK_FamilyID

 

Modification of the Children table.

 

The portal will create the related records using the relationship in the  FK in the process. Each child will be a record in the Children table. There is not need to have more than one field for name and one for the DOB.

 

I also changed the DOB field type fron text to date. If you need to show this info differently, you can always pull out any part of the date using a calculation, or format the Field in Inspector to show only what you want. 

 

Do you know what a ERD is?

Have you looked at the PDF at FileMaker about naming convention?

 

I had some additional things to say, but I think I will wait until you have a chance to reply

 

HTH

Lee

FamilyMod.fmp12.zip