You are correct that it doesn't. That's not the purpose of the "allow creation of records via this relationship" option you can specify in the relationships.
A new record has to be created in each of these two tables before such a value can be automatically entered, and then only via very specific layout designs. The typical way to use this relationship option is to add a portal to Dependent Table on your Member Information layout. Then, when you enter data in a blank row in the portal, FileMaker will auto-enter the memberID from the current record on your members information table into the newly created record in your portal.
If you do not use a portal, then other methods have to be used to get the correct Id number into the field of a new record in either of these related tables.
Note: just to whet your appetite for what is truly possible here, it's possible to set up a single table of names and use self join relationships to link records from the same table. Thus, Spouses and Dependents can also be members in such a scenario.
Thanks for the reply. I have been reading the Users guide pdf and I can't find the steps to create a portal to see if this will accomplish my intentions. I am trying to develop a database that is a church directory. So, I can have children names, spouse names etc... all linked to the Customer ID so people with the same last names, and not necessarily in the same family, ie..."smith" won't cause problems when I try to output them to a printout.
Where can I find more info on setting up a portal?
Home > Designing and creating databases > Creating a database > About planning a database
A well-designed database promotes consistent data entry and retrieval, and reduces the existence of duplicate data among the database tables. Relational database tables work together to ensure that the correct data is available when you need it. It’s a good idea to plan a database on paper first.Follow these general steps to plan a database:
Relational Database Design 101 (part 1 of 3): Designing a Flat File Database
Relational Database Design 101 (part 2 of 3)
Relational Database Design 101 (part 3 of 3)
MY STANDARD LIST OF FILEMAKER LINKS
The White Paper for FMP Novices is useful -
Filemaker Free - Listing of free resources -
Free unlocked templates
By Richard Carlton Consulting
Starting Point -
RCC Blog -
By yzysoft.com Contacts | Products | Invoices | Letters
Sample Database -
A free calendar is available and can be integrated into your database
Seedcode Calendar Free -
Filemaker's Online Help Pages
FMP 12 http://www.filemaker.com/12help/index.html
FMP 11 http://www.filemaker.com/11help/index.html
FMP 9 http://www.filemaker.com/9help/index.html
FMP business database demos - some are fully useable
The Excelisys Business Tracker V3.0 -
Filemaker released a FMP runtime database in 2007 for students called "Campus Productivity Kit" and is available online, notably at CNet
Google "Campus Productivity Kit" https://www.google.com/search?q="Campus+Productivity+Kit"
WIN - http://download.cnet.com/FileMaker-Campus-Productivity-Kit/3000-2124_4-10577579.html/
Mac - http://download.cnet.com/FileMaker-Campus-Productivity-Kit/3000-2124_4-10577567.html/
You can rename the database from a .usr file to a .fp7 file and open in FMP 7 thru 11
Lynda dot com has Filemaker Videos (portions are free)
YouTube - Filemaker Videos
UK FileMaker Channel
FileMaker, Inc. Channel
Lynda.com Channel - Filemaker videos
Dwayn Wright's Channel
Soliant Consulting Channel
Filemaker Academy Channel
Skeleton Key Channel
Accelerate Computer Training Channel
Scoop.it is an information curation site - free option available.
Filemaker Info - http://scoop.it/t/filemaker-info
Filemaker News - http://www.scoop.it/t/fm-news
Filemaker Wikipedia -
Filemaker - Version By Version -
Search specific Filemaker sites with this Custom Google Search
Where can I find more info on setting up a portal?
Select help from the Help menu and enter "portal" in the search box. First article to come up is titled "Creating portals to display related records".
Thanks for the helpful links..I used some of the links to finish my test database. The info seems to be going in well...now I'm trying to figure out how to get it out in a coherent form...like a label. Problem is I'm not experienced enough yet to know how to look for some answers. Maybe somebody can point in the right direction so I know what to look for using the resources above.
I'm trying to set up a label that will print the name of all of the dependents a member may have. THose dependents are stored in the I can get the label to print one of the dependents but don't know how to tell Filemaker to print all the dependents that match with the primary member. I'm including a diagram of my tables with there relationships
If you want to print labels for Spouse, member and dependents all in one print job, your current design will complicate that due to spouses being kept in what appears to be a separate table. It may make more sense to list spouses in the dependents table and use a field that distinguishes a spouse record from dependnets.
If you are going to print one label for each member and their dependents, you can base your labels layout on the "sort dependent" table, but include fields from the related tables to fill in what you need to see on each label.
Thanks again for the help. I look at moving the spouse to the Members table.
How would I get more than one dependant to print out on a label? When I put the field First Name III from the dependant table on the label it print the first dependant. But, if I have more than one dependant and I want to print out all of their dependants how to I add that to a label? Like, if they have 2-7 kids? Any ideas?
Ok, I assumed that you wanted a separate label for each child. You want to list them all on one label?
Then your layout should be based on Members Information so that you get one label for each member. A Portal can list the dependents as long as there aren't more than will fit on a single label.
That worked great...Now I'm trying to correct the spacing between the fields in the portal. For example On the first line is the last name and then the second line has several names in a portal listing the kids names. I made a 1 row portal starting on different inital rows ie...first portal started on row 1, the next portal on row 2 etc... Problem is there is too large a space between portals. If I slide the portals over the spacing changes because some names are obviously longer than others etc..
Is there a way to have filemaker shrink down the spacing as the names get larger and smaller? I tried the sliding function but didn't seem to work. Also, how do I get rid of the boxes around the names?
Use the Insert menu while in layout mode to insert these fields as merge fields.
The fields will appear on your layout enclosed in << >> brackets.
Yep, thought of that also, but then I would keep printing out the first record in that field. I'm looking at calculations too see if I can figure out how to make file maker print the next records in that merged field other than keep printing out the first one.
Your last screen shot showed three name fields so I assumed that you had already worked that out.
A portal to dependents could be used to list the dependents in a vertical list. (The borders can be made invisible.)
Here's a calculation that will list all the dependent first names in a horizontal list:
Substitute ( List ( Dependents::First Name III ) ; ¶ ; ", " )