Cascading Fields

  • Thread starter Thread starter John Norris
  • Start date Start date
J

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

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
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
 
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...
 
Back
Top