Groups | Search | Server Info | Login | Register

Groups > comp.databases.filemaker > #459

Re: Insert a record

Show all headers | View raw

On 29/10/11 8:49 AM, Your Name wrote:
> In article<j8f8e2$fus$1@speranza.aioe.org>, cortical
> <cb@corticaldata.com.au>  wrote:
>>>>
>>>> Do not use repeating fields. They are hammer and chisel technology, and
>>>> break first normal form.
>>>
>>> There is nothing remotely relational about this application.
>>
>> There would be if the data dumped into repeat fields was structured into
>> a related table as it should be. Bad technique, is bad technique. It
>> doesn't matter how simple the database is.
>
> If you're using a second Table to hold Value List options AND you want all
> the options displayed every time, then you donn't need to have a
> Relationship at all.
>
> A Relationship is only needed if you want to narrow down the Value List
> options for each Record based on the data in one of that Record's other
> Fields.
>
> Helpfull Harry  :o)


If it were 'appropriately' coded, the ID values of the 'value list' 
items would be recorded, not the text equivalents.

Then one can use a PUM to display the related text value in the ID 
field. But this facility doesn't exist in FM5 does it Harry?

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Find similar

Thread

Insert a record Bill Steele <ws21@cornell.edu> - 2011-10-05 16:06 -0400
  Re: Insert a record Martin Τrautmann <t-usenet@gmx.net> - 2011-10-05 20:21 +0000
    Re: Insert a record Bill Steele <ws21@cornell.edu> - 2011-10-06 14:03 -0400
      Re: Insert a record David Stone <no.email@domain.invalid> - 2011-10-07 09:12 -0400
  Re: Insert a record John G <greentest@ozemail.com.au> - 2011-10-07 07:55 +1100
    Re: Insert a record clkaufmann@gmx.ch (Christoph Kaufmann) - 2011-10-07 20:46 +0200
  Re: Insert a record Bill Steele <ws21@cornell.edu> - 2011-10-24 13:21 -0400
    Re: Insert a record yourname@yourisp.com (Your Name) - 2011-10-25 13:26 +1300
      Re: Insert a record yourname@yourisp.com (Your Name) - 2011-10-25 16:14 +1300
        Re: Insert a record Bill Steele <ws21@cornell.edu> - 2011-10-25 15:00 -0400
          Re: Insert a record yourname@yourisp.com (Your Name) - 2011-10-26 09:10 +1300
          Re: Insert a record cortical <cb@corticaldata.com.au> - 2011-10-27 09:17 +1030
            Re: Insert a record Bill Steele <ws21@cornell.edu> - 2011-10-27 14:53 -0400
              Re: Insert a record cortical <cb@corticaldata.com.au> - 2011-10-29 08:26 +1030
                Re: Insert a record yourname@yourisp.com (Your Name) - 2011-10-29 11:19 +1300
                Re: Insert a record cortical <cb@corticaldata.com.au> - 2011-10-30 01:41 +1030

csiph-web