Updating Tables

15 pts.
Tags:
Database programming
Hello, I am trying to create a "yes/no" field, that automatically updates when the conditions have been met. Presently, I have two tables that have been created and have a relationship between them. In the first table, is the "master" table. In the "master" table, I have a field called "All forms received?" which is of the data type "yes/no". In the second table I also have a field called "Form Received?" which is also a data type "yes/no" field. These fields are linked together through a submission number. In the master table, there are many "child" tables related to it. I would like the "master" field to automatically update when all the child fields have been checked. Also when we add another record to that submission number, the master field would have to review the new data of all of it's submissions and therefore could be updated again. Is there any way to do this?
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

I assume that this is Microsoft Access?

This logic should be handled via the forms which allow the user to put the data into the various tables.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • alessandro.panzetta
    Let me undesrtand, you want your FORM RECEIVED field of the master table to be YES/NO only when all connected tables are YES or what?
    9,725 pointsBadges:
    report
  • Bmoquin
    Yes, that is the ideal situation. I am using Microsoft Access. I have two tables, and the one field that I would like to update would be on the master table, once the "child" tables have all "reported" in with a "yes". Thanks,
    15 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: