CODEWITHSUNDEEP
relational-databasefilemaker
Tom Prats
Tom Prats

Reputation: 7911

Filemaker Pro Join Table records not created automatically

In filemaker pro 12

Tables:

Relationships:

Both relationships have join tables with foreign key fields.

I'm trying to create a layout with subsummary parts. First I wish to sort by Department. Second by Training. I'm sorting by department number (field of department) and eventName (field of event). The sort displays the two subsummaries and actual works for department but for some reason event is not displaying. Its subsummary can be seen but the values are empty. How can I fix it?

Edit: I've narrowed it down to the Join table for Instructor and Training does not have any records. Is there a reason why related tables wouldn't automatically be creating join table records?

Let me know if you have any further questions about my problem. FMK frustrates me

Upvotes: 1

Views: 3416

Answers (1)

Mikhail Edoshin
Mikhail Edoshin

Reputation: 2669

How do you expect FileMaker to create records in join tables? FileMaker doesn't know which records to link, so you have to create some interface first. To do this you normally set up a relationship to the join table, check a flag to create records, and then add a portal for this relationship and enter some data. As spon as you set it up, it will work as expected. E.g. if this is a portal from Instructor to Instructor-Training table, then as soon as you select the Training ID in the portal row (with something like a pop-up menu), it will automatically fill in the Instructor ID.

Upvotes: 1

Related Questions