Yes/No datatype

[Guest]

I am using a Yes/No Data type (check box) in a customer table. I have a
query that filters on specific custiomers from the customer table, based on
the criteria the user selects. I include the Yes/No field in this query,
which allows the user to check off any of the customers he/she desires to
track later on. The query works great until I add another table and create
a join to the customer table. The Yes/No field will not allow you to add a
checkmark, I only get an error beep. Why is this and is there a way to
alllow the user to apply checks in the query field when there are 2 tables
joined? Or can I only query on the table containg the Yes/No field?

Thanks,
Matt

 

[John Vinson]

I am using a Yes/No Data type (check box) in a customer table. I have a
query that filters on specific custiomers from the customer table, based on
the criteria the user selects. I include the Yes/No field in this query,
which allows the user to check off any of the customers he/she desires to
track later on. The query works great until I add another table and create
a join to the customer table. The Yes/No field will not allow you to add a
checkmark, I only get an error beep. Why is this and is there a way to
alllow the user to apply checks in the query field when there are 2 tables
joined? Or can I only query on the table containg the Yes/No field?

Thanks,
Matt

A two-table Query will usually be updateable *IF* you have a unique
Index (such as a primary key) on the joining field in the "one" side
table, and have established a relationship between the two tables in
the Relationships window.

You can break a query (as far as updating it concerns) by setting its
Unique Values property, by making it a Totals query, or in several
other ways; but just the fact that it's a query shouldn't hurt.

John W. Vinson[MVP]

 

[Guest]

Works great, I just had to create the Primary Key and it worked. I didn't
save the relationship, however I joined the 2 tables in the query. thanks!