Changing values in a field from another table

[springy2003]

Hi, I am working on this borrowing system that consist of two tables. One table holds the data for what is availible to be borrowed (tbl_itemstore) and the other table is the borrowing table that shows what is borrowed (tbl_borrow). tbl_itemstore holds the data for what can be borrowed, has a field where it has a Yes/No data type to say that the item is being borrowed or not, so I could in theory stop duplicate borrowing of an item when it isn't there. But the problem is that in tbl_borrow, I can't seem to change the Yes/No field in tbl_itemstore from tbl_borrow in order for this to work, which means you can still search and find items, which says that they are availible to be borrowed but are not availible. Is there anyway of getting around this problem because I put this question a few days ago and no one could answer it. If you want me to rephase it, just ask me to, since this might not be clear.

Thanks so much for your time, but I have had this problem for a week now and can't get around it.

Richard.

 

[springy2003]

Ok, me again, I just found a way around this, but I have another question, how do you take a value from a field and use it for a search, for example, in a form, you have a value 1 in that box, how do you use a query to search for that value. What expression do I need to put into the criteria?? I don't want

![tbl_item][Fieldname] because that brings up a box where you have to write the value in, I want something that picks a value and use it for searching.

Thanks again for your help

 

[springy2003]

Don't worry, I have done it... Sorry for taking up another thread...

Richard