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: ...
