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