Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 7071 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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,

This topic is 7071 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.