I hav a Table with the following Fields:
ID - AutoNumber
ImgSrc - 00001,000002.....
PO Number 222 , 223 ,224 .....
Status - (default=UNREAD user can change to READ)
Document - bill , letter...........
Job Name - Finch
I have a Data Access Page that displays the data from this table. In the ImgSrc field i have the paths for images and on the Data access page i display the images with a control that lets users navigate forward.
The Question is:
HOW DO I DISPLAY ONLY THE FIELDS THAT HAVE A STATUS VALUE OF UNREAD?
So when the User changes the unread to read he will no longer be able to view these.
Thanks
ID - AutoNumber
ImgSrc - 00001,000002.....
PO Number 222 , 223 ,224 .....
Status - (default=UNREAD user can change to READ)
Document - bill , letter...........
Job Name - Finch
I have a Data Access Page that displays the data from this table. In the ImgSrc field i have the paths for images and on the Data access page i display the images with a control that lets users navigate forward.
The Question is:
HOW DO I DISPLAY ONLY THE FIELDS THAT HAVE A STATUS VALUE OF UNREAD?
So when the User changes the unread to read he will no longer be able to view these.
Thanks