Mime-Version: |
1.0 (Apple Message framework v1078) |
Content-Type: |
text/plain; charset=us-ascii |
Date: |
Tue, 22 Jun 2010 08:09:12 -0400 |
Reply-To: |
|
Subject: |
|
From: |
|
In-Reply-To: |
|
Content-Transfer-Encoding: |
quoted-printable |
Sender: |
|
Parts/Attachments: |
|
|
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:
...
|
|
|