I have a c1dataviewset with a view that is tied to a query in MS Access. The query is made up of a main table, with one field being a code that is linked to a codes list table. The codes table has a boolean "Use" field, so I can change the "Use" from true to false, and display rows from the main table that only have codes that are set to "Use = True". Consider a "status" codes table, with A, I, W (active, inactive, waiting list) that also has a "Use" field. I can change the "Use" selectively for these codes and then want to re-display a C1List that is bound to the view of the query.
The query looks like "select * from (maintable join codestable on maintable.status = statustable.code) where statustable.use = true".
How can I make the viewset and a C1List or C1Truedbgrid reread the info when I change some of the status codes?
Thanks,
James Gunnells