Most Popular Blogs

Today, a colleague of mine at Digital Fusion pointed me to a particular thread on the FileMaker TechTalk Forum in which the poster - Morgan Jones of One Part Harmony posed the following (abridged):

Dear Folks,

I have for many years just used the "Count" function to determine how many related (child) records exist for a given parent record. I just point this function to the unique key in the child records to determine a related-record count.

...

FileMaker Pro is a relational database. Among other things, this means you can relate a record in one table to records in another table. For example, customer records can be related to invoice records. This is a common relationship known as "one to many" – one customer record may be linked to many invoice records. But each invoice is linked back to one and only one customer record.

FileMaker Pro provides a very easy way to create a related record (like a new invoice for a ...

A sub-summary report, is a special kind of report where records are grouped together by a specified field known as the "break" field (because it acts as a break between groups of similar records).

As an example for this article, consider a very basic table containing 3 fields:

• Country
• City
• Population

Each record comprises a country, a city within that country, and that cities population. There may be multiple records for ...

You are probably aware that you can format number fields on a layout. You have many options when formatting as a decimal number including the number of decimal digits (places) and to use notation such as currency or percentage.

But wait there's more. What if we are not formatting currency or percentage? What if we want to format weight or height? These use units of kg or lb, or cm or in respectively. No problems.

When formatting the field, choose to format as a decimal. ...

Building layouts in FileMaker can involve adding a number of various elements such as fields, buttons, portals, tab controls, and graphics such as jpg and png images. It is the use of images on layouts that this article is all about.

You may want to use image files on your layouts for a number of reasons, such as:

• A background fill, ie gradient image
• To be used as buttons, or links
• Images for design purposes, ie rounded edges, shapes, icons etc.
...