Skip navigation

Understanding field types

Understanding field types: FileMaker Pro 11 Essential Training
Understanding field types: FileMaker Pro 11 Essential Training

Join for an in-depth discussion in this video Understanding field types, part of FileMaker Pro 11 Essential Training.

Resume Transcript Auto-Scroll
Skill Level Beginner
9h 11m
Duration
574,645
Views
Show More Show Less

Q: In the Chapter 16 tutorial, “Using Text Functions,” the instructor discusses how to calculate the First Name and Last Name from the Full Name. However, the method does not account for names ending with  “Jr.” or “Sr.” or “III,” etc.  How can I account for added suffixes in names?

A: For cases like this, you can create a third "Suffix" field. Then change the FullName calculation to:

NameFirst&" "&NameLast&" "&Suffix 


This way, nothing will appear if the Suffix has no value, but if it does have a value the suffix will appear.

Q: What information is actually on the “Invoice Line Item” table in the examples, and how does it actually connect to the tables that it comes from?

A: The information in each line item is native to the "Invoice Line Item" table. The fields are defined in that table and each record represents "A Product appearing on an Invoice."
Each time a product is used on an invoice, a record in the line item table is created. Many of the fields, for example "Quantity," are native to that table because those values only exists when a Product is used in an Invoice, and not as attributes of a Product itself.

Skills covered in this course
Business Databases FileMaker Pro

Continue Assessment

You started this assessment previously and didn't complete it. You can pick up where you left off, or start over.

Start Your Free Trial Now

Start your free trial now, and begin learning software, business and creative skills—anytime, anywhere—with video instruction from recognized industry experts.

Start Your Free Trial Now