Yes you could have a separte table for parents. You link the tables with a relationship. You would have a field like parentid in both tables and then you would create a relationship based on this field. You could then put fields from both tables on your layout. You may even want to track father and mother seperate. You would have tabs across the top of your layout and have a table name parents or one each for farther and mother. You could use a drop list incase the parent is already been enter and if not you would have a add parent button which would create the parentid and the parent information.
Normalization is breaking down the data into the basic pieces.
You have Students - Student Table - Unique Auto-Entered Serial number is needed.
You Contacts - Contacts Table - Unique Auto-Entered Serial number is needed.
ContactID is related to StudentID - student can have one or more contacts. Contacts can have only one student.
If Contacts can have two or more students - a join table is needed (called ???) that has Serial Number that relates to the other two Tables.
Many to Many data relationships is generally a bad idea - structure of the database simplifies this into a one to many to one
MY STANDARD LIST OF USEFUL LINKS
The White Paper for FMP Novices is useful -
Filemaker Free - Listing of free resources -
Free unlocked templates are useful for examining design
By Richard Carlton Consulting
Starting Point -
RCC Blog -
By yzysoft.com very clean and elegant 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
Looking at FMP business database demos is useful - 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
Filemaker Wikipedia -
Filemaker - Version By Version -
You can search specific Filemaker sites on this Custom Google Search
Scoop.it is an information curation site - I discovered it three days ago 8/8/2012.
This is my scoop it site - http://scoop.it/t/filemaker-info/
This is another FMP site - http://www.scoop.it/t/fm-news
That helps a lot. However, when I add fields from another table, I want to be able to add the parents name, and have it go the parent contact table. I don't seem to be able to do that. I can see records if I use a portal, but not add records.
Fields can be added to a Layout belonging to the Table that the layout is based on.
Fields can be added to a Layout belonging to another Table that is is related to (or not).Placing and removing fields on a layoutSNIPIn the Specify Field dialog box, select the field to place.To choose a field in another table, choose the table from the tables list above the list of fields. Or choose Manage Database to create a relationship or a table. Then select a related field from the list of fields.
Thank you for this help. I built a small data base to test it. Four tables: Students, Parents, teachers, emergency card.
In the Emergency card layout, I have it set up so I can enter the student's name, and it goes to the student table. I can enter the parent's name, and it goes to the parent's table. I have the teacher's set up as a drop down.
So.. if a parent has more than one studnet in my building... as of now, there name will appear more than once on my parents table. Should the name only appear once? So the name can auto fill from the same name?
Right now I have the same number of entries on all three cards.. The parent's name is repeating over and over again.
I've handled this issue by using a "Family" table to link children and parents. A Family record as the basic contact info and one or more parent records link to it and one or more student records link to it. Not only does this handle the issues you are having, but with a join table added, you can also gain the ability to document "non-custodial" familial relationships should that be needed. ("families" that a student is a part of due to divorce, separation, remarriage, etc.)
Option 1: One family only for each student:
Students::_fkFamilyID = Family::__pkFamilyID
Parents::_fkFamilyID = Family::__pkFamilyID
Option 2: Multiple family records possible for each student:
Students::__pkStudentID = Family_Student::_fkStudentID
Families::__pkFamilyID = Family_Student::_fkFamilyID
Parents::__pkParentID = Family_Parent::_fkParentID
Families::__pkFamilyID = Family_Parent::_fkFamilyID
You'll have to decide which, if either, meets your needs.
Thanks, I'll give that a try. Right now I have students, parents and the join table is Emergency card. I can list the parents in the emergency card, but I get multiple copies of the parents in the parent table.
Would a portal sove this probem? I could also use the portal to add secondary contacts
You need a portal, but just adding a portal isn't likely to solve the duplication. It sounds like you don't have the correct relationship between students, parents and the emergency card table, or you would not be getting duplicate parent records.
I have a table "Parents" and a field "Parentspk", a table "Student" and a field "Studentpk" the join table is "emergency card" and the fields Parentfk, studentfk.
So Should I also have "student_namespk" in the "Student" table and "Student_namefk" in the "emergency card" table?
Im just learning this, and the lynda.com training taked about linking the tables via pk and fk... I wasnt' sure if each field also needed a pk and fk reference.
Or.. does each field have to have a link in the relationship graph (a connecting line.. for got the name)
So your relationships would appear to be:
Parents::Parentspk = EmergencyCard::Parentfk
Students::Studentpk = EmergencyCard::Studentfk
If you enable "Allow creation of records via this relationship" for EmergencyCard in the relationship between Students and EmergencyCard, you can place a portal to EmergencyCard on your Students layout. Format EmergencyCard::ParentFk as a drop down list of Parentpk values from Parents, a secondary field can list the parent names. With that set up you can link a student record to an existing Parent record by selecting a parent in the drop down list in the portal.
Here's a demo file of such a many to many relationship: It demonstrates both the above type of set up and also some more sophisticated approaches: https://www.dropbox.com/s/oyir7cs0yxmbn6i/ManyToManywDemoWExtras.fp7
Thank you for the link Phil, that is helpful!
Ok, Im getting there. Phil, your file really helped a lot. I have this somewhat working:
Three tables: Students, Parents, and Emergency card
I have the Emergency card set where I can enter data for the studnets and parents. I also have a portal that if the parent is the parent of another studnet, I can click on the drop down and select the parent.
Good news: It works, I have 8 studnet entries, and 5 parent entries.. so im not duplicating names..
Bad news: The name does not fill until I click out of the portal, and then it fills another parent ID value in the row below. (don't want it to do that)
also... I would like to beable to use the drop down and select another parent (as a seondary contact) but the list won't let me do that.
here is the link to the file:
Any help would be great.
Using the portal, you should be able to select as many parent contacts as you wish. Each on a different row of the portal.
Your layout doesn't match my recommendations.
Base the layout on Student or Parent. Base the portal on Emergency Card.
Put the drop downs for selecting the "other" record (the parent on a student layout, the student on a parent layout) inside the portal, not on the layout.
Emergency Card represents a specific "in case of emergency" link between one student record and one parent record. You then create as many records in the portal as you need to document emergency contacts. You can add a field to your emergency card table that you can use to designate a specific record as the preferred emergency contact to use and your portal can have a sort order to list that parent first.
Ok... Thank you, that gives me a better direction.