Dang. And thanks for the ideas.

Geoff

On Jun 22, 2010, at 2:33 AM, Richard S. Russell wrote:

> On 2010 Jun 21, at 22:37, W. D. wrote:
> 
>> There might have been some discussion about this
>> some time back, but what fields ... would you recommend for all databases?
> 
> 
> Every file I create has an "F" table in it. "F" stands for "file", and it's the table where I store everything that's unique to that particular file. The "F" table has only 1 record in it. "F" is cross-linked to every other table in the file by means of a One x One relationship. It's also the place where OTHER files store the default values for new records to be created in one of the tables of the current file.
> 
> In addition to all the standard fields in the "F" table, every OTHER table in the file also has a bunch of standard fields.  Fortunately, FMPA makes it really easy to copy and paste such fields from one table to another.
> 
> Here's my standard set of fields, using tabs that may or may not show up in your e-mail:
...