bcooney

Boy, this should be simpler. Is this relevant? https://www.portagebay.com/blog/2016/8/26/containers-and-port-16000-in-filemaker

https://www.teamdf.com/blogs/change-containers-from-files-to-interactive-content-in-an-instant/

Rich. Super container and external storage are mutually exclusive.

So, a customer can have many Aircraft? If Customer>Customer_AirCraft<Aircraft Spec is true, then you should have two foreign keys in Customer_Aircraft: the CustomerId and the AircraftId. What is the primary key in the Aircraft_Spec table? That should be what relates from Aircraft_Spec>Customer_AirCraft.

You could create a calc field, premiumIsPositive=premium>O. Then count that field. Or, do an ESQ call. Or, do a Find.

ScriptMaker?? What version of FileMaker is this? Edit: FM7? on what OS?

I'd consider a summary table Summary tables

Never use this type of value as a relationship key! Let's see your new relationship graph after you refactor the relationships. Also, why do you name the Aircraft table Customer_Aircraft? I find that confusing. It sounds like a join table, storing data about the many aircraft a customer owns and attributes of that ownership. I'd change that table to simply, Aircraft. Please study up on Anchor-Buoy!

Are you aware of how to use the Find command? Scripting buttons to go to specific records isn't often needed. Use Find.

You have only one chance to set a $$externaldatasource. It cannot be changed once it is established. Why do you have several data files? Couldn't you use a date field to count records within a range?

You should not use registration as a key if it's a value that you have no control over and if it is not unique. I see many relationships in your system that are questionable: You're relating Kit>KitItems by Description! Should be by KitId ATAChapter? Is that a field you control? You didn't answer where Registration is created. By your system? What is it? (auto-enter serial?). Why do you have a PrimaryKey field if you don't use it for relationships? Also, before you go much further, I would strongly suggest adopting a convention for the Relationship Graph. I prefer Anchor-Buoy, but you need to do something. This will not scale well.

Agreed, you shoukd select balance sheet. What I don't follow is the keys you're using to relate your tables. I would have expected customer to relate to aircraft by customer Id. What is the value in registration and why is it a key?

Start here. https://www.filemaker.com/partners/find-a-partner/

You might want to check out this javascript approach: https://www.soliantconsulting.com/blog/pivot-table-filemaker

Before you jump into an Audit log...what is your specific need? Why do you need to report changes?