title: Database field manipulation
body: <p>I've recieved a database, it is very complex so it's hard to get my head around it. I offered I would clean it up for the owner but looking at the mass of relationships i'd probably change something for the worse. However there is one problem i wish to fix for them, there's a field named LoanStatus the properties are; 
  -Text
  -ComboBox
  -RowSource: "Current";"Returned";"Overdue"</p>
  
  <p>The problem I'm having is whenever you loan out an item, you fill in the row with the asset number and the system will return a due date for you in that row but the problem is, you're able to loan out the same item an infinite amount of times in different tables (to different people), i want to have the LoanStatus field say "AlreadyLoaned" whenever you try to loan it out when it has already been loaned. Again I just got a headache by writing this but i hope you guys will understand it. Thank you for your time!</p>
  
  <p>Im using MS Access 2007</p>