Portage Bay is looking to hire a new developer to join our team of FileMaker and 4th Dimension developers. We’re a group of experienced developers, some certified, some not, that work together on a variety of projects for clients in different industries, education, and government.
Relationships are the basis of relational database design. When set up properly, table relationships will ensure your database runs like a well oiled machine. However, sometimes we run into systems where relationship keys are open to the user, exposing data to the risk of human error if a relationship is changed improperly. It’s sometimes desirable to refactor these relationships to use a proper artificial key relationships to connect tables, a laborious task depending on the size of your database. This post discusses a convenient trick to populate Primary Keys, a reminder about mismatched data types, and a modular script to help populate foreign keys when refactoring a key relationship.
When developing FileMaker solutions, one of the issues that always comes up is the lack of Version control options. How can you use Version control with FileMaker, and what is it? Read this article to find out.
We had an interesting request on a recent project where the client wanted to navigate two portals on a layout using the keyboard. The portals needed to be setup in a way that makes them appear to be one large portal with a static header row in the middle. The client also wanted the interface design to allow for very fast data entry. We concluded that using the navigational keys to navigate the portal would be the best choice, since it performed similar to navigating a spreadsheet.
FileMaker gets a lot of attention in our blog, but we are doing ongoing development and support on 4th Dimension applications for about 10 clients currently, keeping at least one of us at Portage Bay busy doing 4D development at any given time.