Updateing Records

November 12th, 2005, 11:40 PM

Reggie

Guest

Posts: n/a

Hi and TIA! I have a form were the using can reset the priority of the
record. I then want to add or subtract 1 from the other records depending
on what they change it to. Example:

Form
TypeModel Priority
A 1
B 2
C 3
D 4

If they change C to 1 I want to add 1 to A and B but not D
If the change B to 4 I want to subtract 1 from C and D but not A

Any sugestions would be appreciated. Thanks for your time!

--
Reggie
----------

« previous question | next question »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Design Question	Lee	answers	2	March 3rd, 2006 08:05 AM
Trigger on Postgres for tables syncronization	Prabu Subroto	answers	5	November 23rd, 2005 01:30 AM
Updateing a database table from a dataset	Jake	answers	7	November 17th, 2005 08:07 PM
INSERT Cyrillic to Access DB via ASP ?	Beast	answers	3	November 12th, 2005 07:27 PM

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 225,702 network members.