A third way to perform a Find in Browse mode uses a feature called Saved Finds.…Saved Finds works through a new icon that you can see on the Status toolbar.…However, if you do not see the icon on your Status toolbar, you will want to go…under the View menu to Customize Status toolbar and pick Saved Finds and drag it…to a location on your toolbar, and hit Done.…And if you click and hold down on the icon or click on the arrow, you'll see…that there are various different options that appear.…First, you can see something called Recent Finds and then you see Saved Finds.…

A Recent Find is a find that you've performed during this database session,…meaning while you had this file open.…A Saved Find was a recent find that the user has chosen to save for future reference.…So, for example, next time you open up the file, that Saved Find will still be…there, unlike Recent Finds that clear out after your session clears.…Sessions are specific to multiuser mode, so when a file is being hosted on a…server, you get a session every time that you log in to the server.…

Resume Transcript Auto-Scroll

Author

Released

6/25/2010

In FileMaker Pro 11 Essential Training, Cris Ippolite demonstrates the principal features and functions of this popular database software, including creating tables and relationships, managing fields and records, and working with layouts. The course shows FileMaker developers how to find, sort, and share data as well as how to create reports, calculations, and scripts. It also covers brand new features in FileMaker Pro 11 such as the Inspector tool, charting, and portal filtering. Exercise files accompany the course.

Skill Level Beginner

9h 11m

Duration

576,787

Views

Show MoreShow 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.