ms access - I need a yes no field but the table doesn't have one .The table is read only to me -

my task @ work produce , without unnecessary effort, “approved supervisor “ set of records print off via report .this done weekly records identified using select query run aon linked table on have no control, read access.

problem 1)i working regularly updated source table on intranet . table cannot edit in way . nor can else edit it. table not have yes /no field can link table
please refer table in answers “tblsource”

my workaround far :- current working prototype idea achieved approval via yes/no tick box field facility added in. (tick box speediest way work through selected records , give “approved supervisor “ (that’s me ) approval . selecting records via combo box far slow ) have done make table query , manually adding yes/no field “tblmade” leads problem 2) ..

problem 2) maintaining “approved “status of records until next time list accessed ,when records may or may not still exist in source table . problems in current work around .. using make table query seems means fresh start every time ie records erased re populated , replicating lot of work in approving existing records again

my additional thought overcoming problem 2) -would possible create kind of query against tblsource populate table checked boxes remain intact against unique records ie primary key of source table have research dlookup cannot yet see way of achieving -------------------------------------------------------------------------- happily elaborate on work have , nature of problems encountering

some further info
primary index in tblsource txt field unique serial numbers /letters other 3 fields tbsource use txt fields

problem 1) source tbl not have yes/ no field , source table available linked , cannot modified ie read privileges

problem 2) tblsource updated/ changed daily around 5-8 % deletions , or additions not large data set there 1100-1200 records in tblsource , after simple select query have scan 150 -200 approve or not

please note profile ,my ms access skill levels beginner moderate can build macro raw vba still way off can cut , paste pretty if point in properties list put eg data - “onupdate “ etc

this quite easy.

add new table tblforapproval contains id field (this foreign key tblsource table - therefore define appropriate relationship in lookup tab), , approval field (yes/no).

then create new form , define data source in way left-joins tblsource tblforapproval.

then add text fields , check boxes form , bind these return values of query (see screenshot - property sheet - data - control source [field "approved" has been linked table column "approved"). don't forget checkbox approval , relevant save , next record buttons.

this more or less it. can navigate through record sets. if haven't given approval yet, left join deliver empty value, access automatically add record in approval table once save record.

this method survive updates source table - approvals saved separately.

by way: not require vba unless want "auto-save on clicking approve".