
Most of this is due to its age and keeping a strong commitment to backwards compatibility. No matter what your needs are, I can promise that short of a real-life magic wand, the info in this video will put you on the path to solving the problem you think Claris/FileMaker can't.Ĭlaris/FileMaker, as a development environment, is full of all kinds of hidden corners and secret places.

It's always just a matter of knowing where and how to look and then integrating what you find. In this video, I'll show you the technology you need and how to integrate the technology to pretty much solve any problem. You simply need to be willing to step ever so slightly just outside FileMaker and your result will be found. Enjoying your sweets and treats as much as you like! There is, quite literally, nothing I can think of that can't be done just outside FileMaker and brought back in to the software.ĭo you need OCR? AI processing? Serious image manipulation, complicated heuristics, complex PDF manipulation, data scraping from HTML or anything else? You name your need and a solution can be found.


It's sort of like always being able to say "Yes" and never having to tell yourself "No". This makes scrolling through records unattractive as you need to keep switching layouts to see data.One of the greatest joys I get from working with FileMaker is making it do something it doesn't do natively. Through a relationship ( and here I am bamboozled), I am endeavouring to create a new record, either from the Vendor or the Purchaser, in the Correspondence table whereby entering either client key, the relationship will 'recogonize' which table to upload the Full Address details from.Īll I can come up with is creating two sets of Full Address and relationships with two layouts from both - One for the Vendor letter and the other for the Purchaser. They also have a field defined as Full Address.Ĭorrespondence Table has fields Client Key, Full Address (amongst other of course).

I wish to create correspondence to either the vendor or the purchaser and merge their address details into the correspondence table.īoth Vendor and Purchaser have a unique Client number. Is there a way to merge data derived from two tables to a third.
