I want to create a new tab on the event details layout. I have copied the layout used in the Payments Tab and plan to use this general form. (The New Tab will be a simple inventory Tally sheet). I will need to create a new table. I have hit a roadblock in that the tables are on the External Data File. Uncertain how to create new ones. Also, I was wondering if it is possible to use the same script button that creates new lines. I realize that it will have to be edited. However, being a novice, reverse engineering is the only option for me.

Any Suggestions?

Hi,

So you'll create new tables in SeedCodeData.fp7, and you'll add them to the graph and create layouts/tabs that use them in SeedCodeComplete.fp7

To create a new table, open Complete and select "Show Window" from FileMaker's Window menu and you'll see SeedCodeData as a widow. Select that window and then select "Manage / Database" from FileMake's File menu. Now you're in and can define fields and tables. You only need to create relationships in SeedCodeData to support things like lookups or calcs between tables: the normal relationships you'd set up for portals will be done in SeedCodeComplete.

So once your table is defined, you can return to SeedCodeComplete, add a table occurrence for the new tables to the relationship graph in Complete, and work with the table occurrence as if it were in Complete.

Some more notes about how the solution "separates" data and interface into these two files can be found here: http://www.seedcode.com/pmwiki/pmwiki.p ... ationModel

You'd also asked about scripting a button to create new lines. Yes, we usually copy one of the working scripts and modify it to create lines in the new table. The "new line" button on Event Details is a good one and the script it calls ("Create Invoice Line For Event") could be a model for your new inventory tally lines, but that script is probably more complicated than it needs to be inventory lines.

Since you're new to this you could just set the relationship up to "Allow the creation of related records" as that would create new inventory tally lines by simply typing in the next open row. Or if you needed a script but couldn't write it yourself, you could hire us to make the modification for you. Just get in touch

John,

Thanks so much.

Andy