Cascading Fields

[John Norris]

Lets say I have four text fields 1, 2, 3, 4. I always
enter new information into field 1 but I need to have the
old Field 1 information automatically (or close to it) be
written to Field 2. Like wise old field 2 info to go to
field 3 and also old field 3 info goto field 4. The old
field 4 info just gets lost on the floor! Its OK to have a
button to start the sequence. It would empty 4 then write
3 to 4, then write 2 to 3, then write 1 to 2 and finally
clear field 1 for a new entry. Reminds me of a cascade
waterfall!

JOhn

 

[Rebecca Riordan]

John,

It sounds like you're describing a repeating group, which is a bad idea.
What exactly are you doing?

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...

 

[RobFMS]

Have 3 hidden fields: txt1to2, txt2to3, txt3to4

Before an item is written to txt1 (the BeforeUpdate event), set:
txt3to4=text3
txt2to3=text2
txt1to2=text1
text4=txt3to4
text3=txt2to3
text2=txt1to2
text1=<new value>

This is not tested, but just thought out in a logical fashion....
--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[John]

Thanks for the Reply,

It is for small business telemarketing. It will keep track
of the last four contact events with a customer. Also
allows for fast entry while on the phone with the
customer, no copy and paste needed.

John

 

[Rebecca Riordan]

Don't do it this way. Really, trust me, you'll regret it. Make
"ContactEvent" a separate table. You can display it this way on the UI, but
DON'T do it in the table design.

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...