scratching my heaad

[doC]

A couple of things have come up that have me baffled.. new to FM 5.5.. i have created a invoice db. (permits) wish goes out to a value list from another Inventory db (rooms).... how do i indicate to the user that the "room" has been booked/SOLD for that particular date ... also how do i Clear the "SOLD" status on the check-out date/time automatically..? i am thinking of tagging SOLD rooms some how but not sure if that is the way to proceed.. any thoughts would be appreciated..