Update Query, maybe?

[steve1111]

hello,

i am not sure i am on the right path. I have a table [rides] that is a read only link to a third party so the simply option of adding a field in that table will not work here. i have a query that runs from the [rides] table to show me all the cancelled rides for today. What i want is an additional checkbox field called "reviewed" so if the user clicks yes on the reviewed field in the query subform, the next time the query refreshes that record falls off.

I am not really sure the best way to "add" the reviewed field since the table is read only. I think somewhere along the lines of an update query but i have little experience there.

thanks for the suggestions

 

[KenHigg]

You need a table that has a fk back to the rides table pk, kind of a 'local rides' table. Then you can add whatever attributes you want back to the ride events...

 

[steve1111]

Ok but then how do i update the 'local rides' table when i change a checkbox to true?

 

[KenHigg]

So you have a form that lists the rides from the main table. Then you have a subform that is based on the second table and link the two tables. When you navigate to the ride in the main form you will have a place in the second table to add a record which will be associated the the record in the main table -

 

[steve1111]

Ok, that gets the wheels turning a little, i will give it a go.

 

[KenHigg]

This is a powerfull concept that will allow you to kind of create a modified or hybrid version of an enterprise level table...