The Support Group Blog

Claris introduced a new feature in version 18 of the FileMaker Platform called Save a Copy as XML. You can find this command within the Tools menu if you have the "use advanced tools" option enabled in the FileMaker desktop application's Preferences section. With this menu command, Claris gives us a window into each of our custom apps' inner workings, as well as a way to more easily document even the most complex ones.

Extensible Markup Language (XML) is a web development tool used to store and transport data. Like HTML, which is a markup language for data presentation, XML requires opening and closing tags. XML is useful for FileMaker development because it facilitates the exchange of data between two systems. However, we can also use it to parse or read our data. In this article, we'll explore how we can protect the integrity of our FileMaker applications as we scale and evolve them.

Common Types of Relationships 

Previously, we discussed one-to-many relational databases. By far, this is the most common type of data relationship that we encounter. We discussed parents and children. A parent record can have many child records, but a child record belongs to one and only one parent record. Those relationships are defined through data. A parent record has a primary key that is assigned when a record is created. A child record displays part of the DNA of its parent by carrying the unique parent ID in a foreign key field. When the child’s foreign key value matches the parent’s primary key value we have a link between those records.

Other types of relationships occur as well. In this article, we’ll cover one-to-one and many-to-many database relationships.