Dave,
Thank-you. I am working on normalizing my database as suggested.
Looping through 10 rows is no big deal, but needlessly looping through 5000
rows is inexcusable. Slapping myself in the back of the head for not
thinking of that to start with...<cf_slap>! <cf_ouch>
Having some problems with the third table though. The entry form for a
new record contains the checkboxes to enter the new person into groups. The
processing template updates all the other fields into Table 1, but in order
to enter the groupID's and the ContactID into the junction table, I need the
ContactID that is assigned in the update. Do I do this by just doing a
query directly after the update to pull the new Contact ID out? I tried this
approach, but can't seem to get the data to enter into the 3rd table. Any
suggestions?
Thank-you again for the sound advice,
Christine
----- Original Message -----
From: "Dave Watts" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, June 24, 2000 4:50 PM
Subject: RE: Global replace dynamically?
> 2. The best solution, of course, would be for you to normalize your
> database. You wouldn't face problems like this with normalized data.
Instead
> of using a list of names in a field in Table1, build a linking table,
which
> would have two fields: ContactID and GroupID. You'd use this linking table
> to build a many-to-many relationship between contacts and groups. I can't
> overstate the importance of a well-designed data schema.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
