I am in the learning curve of the FileMaker 7 power. One great thing from this new version is the ability to have more than one window open at the same time. And in my solutions I used to define some globals. I perform validation through a script using the data that the user inputs. This way data can be modified before the record is created. With earlier versions there was no problem since every file had it's own globals.
Now, with version 7 and all the possibilities you have in the relationships dialog box it is entirely different.
I am still trying to recreate the same way, so:
1. I create an extra table with all my globals(defined as globals so they can be accessible from any table in any layout).
2. I define as many relationships to the other tables. One for view and one for create each item in a portal. For example,
Invoice::LineItems -> will have InvoiceID on the Invoice Table and InvoiceID on the LineItems table. An I will have all items of that invoice in a portal
Globals::LineItems -> will have gInoviceID and gProdID on the Globals Table and InvoiceID and ProdID on the LineItems Table. This way I verify the ProdID is not duplicated, before the record is created.
I would like to know if somebody works this way and if you have found some problems. Probably when you host your file somethings won't update correctly.
I have done some testing on a shared file and nothing has come up.
Any Suggestions?:
Thanks,