Just saying that FileMaker Advanced has tools to do what you want very easily. "Regular" FileMaker Pro does not. Call FileMaker and ask for an upgrade and pay the 200 clams (depending on your geographical/political location, of course) and get Advanced. Then start reading the documentation that is plentiful on the FileMaker site: http://www.filemaker.com/support/product/documentation.html
Another place to start is with the migration documents such as this one for FileMaker 8: http://help.filemaker.com/ci/fattach/get/9202/
You will get a lot of good information about moving from pre-7 files to 8, which isn't quite 11, but it is a lot closer to 11 than it is to 6, so the basic principles apply.
I'd also like to address another of your points: A table does NOT have to equal a file. A .fp7 file (FMP 7 - FMP 11 are all use the .fp7 file format) can have many tables and, as a matter of general principle, is a lot easier to work with when all your tables for a particular solution are in one file. It makes relating your files in the relationship graph a lot more intuitive.
Good luck, and keep asking questions. While it would be more efficient for you to read up and know the terminology so you can ask more accurate questions, please continue to ask about the parts that stump you.
j.
On Jun 5, 2011, at 7:26 PM, Andrew Gordon wrote:
> Dear Jonathan Fletcher, Steve Cassidy and others,
>
> We are using FMP "regular". We have made the jump from FMP 6 to FMP 11 with some difficulty but are making some headway with the big FMP Manual, the User's Guide and FMP Help. Some things are not clear though and the answers don't appear to be in these resources, hence the posts to the FMP List.
>
> Part of our confusion is the difference between a file and a table - our view it that they are the same thing, perhaps we are wrong in our understanding of the terminology. We store data relating to a particular year's production in a folder for that year, containing the 3 files for that year, e.g. Receival10, Processing10 and Inventory10. Each file may have a number of layouts. We generally have a "data entry" layout, then create layouts as needed within the file.
>
> We use look-ups to transfer some info from Receival to Processing and then Processing to Inventory. As the inventory file is specific to the production year, we create other look-ups from the current production year inventory to the previous years, i.e current [2011] to 2010, then another from the current inventory to 2009 inventory etc etc.. This enables us to have an inventory on current year's stock of saleable items and the carry over of previous years' saleable items.
>
> When a client makes an inquiry about a particular item, we would simply open the current inventory file [with the look ups to previous years stock balances], and find the stock balance at >1.
>
> This worked fine in FMP 6 and earlier but we are having difficulty setting up the same in FMP11 "regular".
>
> On 05/06/2011, at 9:58 PM, Jonathan Fletcher wrote:
>
>> Are you setting up a new table in the same file or a new file? If you are creating a new file you may use the Rename File function in the Developer Utilities of FileMaker Pro "Advanced" to rename all the internal references as well. More info on Page 9 here:
>> http://www.filemaker.com/support/product/docs/fmpa/fmpa11_development.pdf
>>
>> j.
>>
>>
>> On Jun 5, 2011, at 2:31 AM, Andy Gordon wrote:
>>
>>> I would like to use a table as a template for a new table that has the same fields etc. When the new file/table name is given to the new blank file, the old file name seems to remain when trying to set up relationships.
>>>
>>> TIA
>>>
>>> Andy
>>
>>
>>
>>
>> --
>> Jonathan Fletcher
>> FileMaker 9 & 10 Certified Developer
>>
>> Fletcher Data Consulting
>> [log in to unmask]
>> http://www.fletcherdata.com
>> 502-509-7137
>>
>> Kentuckiana's FileMaker Users Group
>> Next meeting: June 28, 12:00 pm to 3:00-ish
>> Listserv signup: http://fmpug.com/mailman/listinfo/louisville_fmpug.com
>> Blog: http://www.kyfmp.com
>
> Andrew Gordon
>
> V: 03 5024 8812
> F: 03 5024 8834
> M: 0407 309 961
> Skype: andyatkc
> P.O. Box 1054, Mildura, Vic., 3502
--
Jonathan Fletcher
FileMaker 9 & 10 Certified Developer
Fletcher Data Consulting
[log in to unmask]
http://www.fletcherdata.com
502-509-7137
Kentuckiana's FileMaker Users Group
Next meeting: June 28, 12:00 pm to 3:00-ish
Listserv signup: http://fmpug.com/mailman/listinfo/louisville_fmpug.com
Blog: http://www.kyfmp.com
|
