CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.

YesSoftware Forums -> CodeCharge Studio -> ASP

 Only change a field if a related record meets criteria

Print topic Send  topic

Author Message

Posts: 1
Posted: 10/01/2009, 7:33 AM

I have a problem and I am not a very good programmer

I have a table with the following fields


The table is a shopping list but I only want to set the AVAILABLE field to 'YEs' for a record if a related record has had the SENT field set to "YES"

Here is an example. I rent videos in parts. I only want to have the part 3 available of video1 if part 2 has been sent to the customer already. I do not want to send part 3 if the customer has not had part 2. Likewise to send part 2 , part 1 must have been sent.

Please can you help me. I have tried to do this using ASP and MSaccess queries but to no avail.

I am using CSS4 and msaccess.
View profile  Send private message

Posts: 1
Posted: 10/04/2009, 9:14 PM

I am sorry, but the information that you have provided does not compute at all.
What exactly is it that you are wanting to do.
Try writing it out a little better than you have done in your first attempt.

View profile  Send private message

Posts: 339
Posted: 10/08/2009, 2:42 PM

Yes, we need more information.

Give us a sample of a record. What do listID, ItemParentID, etc. represent?
View profile  Send private message

Add new topic Subscribe to topic   

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.

Home   |    Search   |    Members   |    Register   |    Login

Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by  and YesSoftware, Inc.