1 of 1 people found this helpful
1) Yes, the Figure 3.6.1 shows "CUSTOMER" (this is just an example of the relationship graph, it should not apply directly to the lesson/example db).
2) and Example 3.6.1 has this para:
Click the Add a Table button at the lower left (the furthest left button with a single green “+”). In the Specify Table dialog, choose the Vehicle table. In the field labeled Name, enter “person_VEHICLE”. You may be wondering why you appear to need to give the Contact table an additional name. This is explained more completely in Lesson 3.7. That lesson also explains what it means that this is the second time the Vehicle table appears in the Relationships Graph.
The sentence "You may be wondering why you appear to need to give the Contact table an additional name." is confusing to me, too.
You are making another table occurrence of "Vehicle" and naming it "person_VEHICLE".
3) and this "Figure 3.6.7" shows "CUSTOMER" and customer_CONTACT. This is also another example of the Edit Relationship dialog. It does not apply directly to the lesson and the "03a_VehicleTracking.fmp12" database.
I didn't write these lessons, but am merely pointing out what I think you found confusing. If you find other "inconsistencies" in the lessons see if you can take the examples as "examples" and not necessarily "literals". Come back to the list if needed.
p.s. I'm an author and a tech-editor, so know that these "uh-oh's" can happen no matter how many people proof the copy.
The material has been great up to this lesson, but in the version I downloaded this lesson seems to have a mix of two different databases, vehicles and contacts, and the relationship created in the lesson does not work for me. I downloaded FTS_12.0.1_English on July 20, so I would think it would be the most recent?
Thanks, I understand what you are saying, but Example 3.6.3 says
- The Edit Relationship dialog should appear as shown in Figure 3.6.7.
which in my version shows the figure
but I guess it could be exemplar rather than literal.
I ran into the problem of not understanding until later that you cannot enter the vehicleID because it is auto-assigned and not-modifiable. I figured this out, but until then, I had trouble understanding why it kept saying that field is not modifiable. I finally figured out the other fields can be entered, and then it will auto-generate the VehicleID number.
It could be more clear, but I figured it out after a little while.
Yes, tommyal, that was unfortunate wording: "should appear as shown", does NOT match the tables for the example you are asked to study. "exemplar" not "literal"!
VehicleID is only auto-enter and not modifiable in the Vehicle table. PersonID is also auto-enter and not modifiable in the Person table. The exercise is meant to JOIN these two tables by creating the new table occurrence, "person_VEHICLE" after adding the foreign key "PersonID_fk" in the Vehicle table and placing the new table (alias) on the graph (as in Figure 3.6.3). But it sounds like you figured it out!!
One thing that might help you is that all example files for you to work on are in the "Module 03 Exercise Files" and the finished databases can be viewed in the "Module 03 Solution Files". If you're not sure what's to be done look at the finished databases.
Again, I agree that the figures aren't matching the assignment text at all times and could be more clear! Don't hesitate to come back to the list and ask if you need more explanations on the FTS 12!
Perhaps the authors and/or FMI could post a forum topic here just for the FTS and also post any errata that might help clear the confusion!
Thanks Beverly, I indeed overlooked the solutions folder and I will look at that too. What you wrote is better than the lesson, sounds like you would do well at this.
Appreciate your help.
Where you downloaded sample file?
1 of 1 people found this helpful
The sample files are part of the FileMaker Training Series (FTS). There are two versions:
Advanced (free to forum Subscriber members)
see this link for more information: