Checkbox: Can I update another table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database with several tables. One is the 'Master' table
(Mastertble) and others are sub-tables. (ie. Customertbl)

I an creating a form and am using a checkbox. The forms property is set to
Mastertbl. I am adding a checkbox and would like a field in Customertbl to
be updated. Can I do this without creating a relationship in a query?

If the above is possible, what is the command to do that & where do I enter
it?
 
You can include more than one table in your form. Without knowing more
about your database structure, it would be hard to give you too much
guidance.

In short, pull the field you want to the query, then to the form. If the
two tables have a one-to-one relationship, then this would be very easy to
do without changing your form much. Just include the second table in your
query and pull that field into your form.

If the tables have a one-to-many relationship, then you would need to maybe
add a subform using the second (many) table as a source. This would give
you a main form with the primary record and a subform with one or more
related records in your subform.
 
Back
Top