Access Access question, How to Flag A Record?

[Joe1992W]

Hi Guys,
In desperate need of some help here!

I have a Database of Job Vacancies, In order to keep on top of the Database I would like the end user to be able to flag a record "Job" as "Unavailable" which would massively reduce the leg work needed to be done by an admin.

I initially thought the most straight forwards way of doing this would be to have a field named "Flagged" with a validation rule of "Yes" Or "No" and default value of No.

I then planned to set a command button which would change the value of the flagged field of the record being viewed at that time to "Yes".

An admin could review all records that have been marked yes and delete as appropriate.

Any advice as I have hit a brick wall because my DB experience is next to none.

Thanks

Joe

 

[projecttoday]

You could have a fill-date field. When the job is filled, the user enters the date. To retrieve unfilled jobs, query the table where fill-date is null.