8 posts in this topic
I can't figure out how to subtract the total of several child records from a starting value in a parent record: Sounds simple, but it's got me stumped!
My database is designed to issue Emissions Reduction Credits to companies for reducing or eliminating sources of air pollution. Those companies then later use those credits to offset new construction, sell them to other companies for cold, hard cash, transfer them to other companies, etc. The initial issuance is all on one Certificate and there can be between one and five pollutant credits on each individual Certificate. A company can own many certificates, but a certificate can only belong to one company. Once issued, a company can use the credits all at once or (more likely) a little at a time. After each use/expenditure of credits, the certificate is reissued with the new balance of credits listed on it. Thanks to a lot of great help in the Relationship subforum (Thanks again, Don and Bruce!), I've got the basic architecture down and issuing the initial credits works just like it should and the FIRST instance of credit usage calculates the new balance correctly, but when subsequent uses/expenditures are entered, the new balance ignores any previous expenditures.
I've tried dozens of different calculations, added TOs, lumped all transactions into one TO, filtered portals, and barked at the moon, and nothing works (though I did manage to scare the bejeezes out of my cat!)
I have attached my semi-sorta-solution to help clarify my problem. It should open to the "Certificate" layout - the bottom portal has the usage data that isn't calculating the new balances correctly. Any help in getting this up and running would be most appreciated - thanks in advance for sharing your time and talents.
FMPA 15, Windows and Mac
ERC Registry v2 ModBFR Bad ERC Balance.fmp12
By Roger Tuan
Is it possible to sync data in a Filemaker portal to an external MySQL database? For example, an invoice listing multiple products stored in another table (assuming I only want the information in the portal, such as qty, name, price).
Or do we have to manually sync all related tables behind the scenes and then re-create the relationships using joins later?
By Scott Pon
Environment: FM13 with FM13 Server, mix of Windows 7 and 10.
Is there a way to set a script trigger on if this portal row is new? IE, a script to run if this new child/portal record is new.
We have a parent record, and portal to Children records. The children records have 2 fields: Profile Name and Process type. Our user would like to enter a new child record (profile name and process type). if the process type already exists, we will need to archive the existing record (matching the profile type). There is more bI want to start with this first.
I see script triggers to the layout "OnRecordCommit", but no similar script trigger for portals. Any ideas on how to handle this? Or am I going to have to add a button to go to another screen to accomplish this?
Thanks. I hope i gave enough info for you to help me.
By Sergej Ivanov
Hi, I got stuck with building a proper relationship scheme.
I'm making an database with several tables. One table contains information on archaeological features (key field Feature ID), another contains data on documentation. One document may contain information on several features, for this reason in documentation table I've created several fields (Feature ID 1, Feature ID 2, etc). The two tables are related through Feature ID=Feature ID 1; in the second table I've made a self-relation between all Feature ID fields.
In the Features layout I've made a portal displaying related records from Documentation table. Unfortunately it only displays related to the first field (Feature ID 1), while other fields (Feature ID 2, etc) seem remain unrelated.
What do I do wrong? Thank you!
Im currently using a portal to relay certain information from my main database, the information that is related between the two are the fields of 'Brand' and 'Part Number'.
The only other fields i have in my portal will be
1. Sale Or Purchase (a drop down list to select either sale or purchase).
Is there any kind of calculation so that when i select either the 'sale' or 'purchase' option in the drop down list that it will either add or subtract the quantity i then enter into my quantity field, this way my stock list can keep up to date with the correct quantities?
Brand - ddd
Part No. - 123
Quantity - 3
Date - 22/02/2013
so after i have entered all of this data because i have sold 3 i need my calculation to take 3 away from the overall stock, and for the calculation to add 3 if this was a purchase
hope this makes sense