yandoo Posted February 12, 2007 Share Posted February 12, 2007 Hi i was hoping for a bit of help if possible please... ive created a database which loans laptops to users. I have a table detailing "laptops", a table detailing "loan information" (laptop loaned to user) and table detailing "users". This is how the form is structured: Loan ID Users Name - Users table Date Time Laptop Name - Laptop table Complete Y/N Description I have created a loan form that details all of the three tables details. Using the "Laptop" table, i have made a dynamic select menu of the laptops avaliable for loan on the form. My problem is that when the laptops are on loan they will ALL still appear i the menu. THIS is where i need some help please??!! I need to make it so that if the laptops are out on loan(i.e. "Loan completed" Select menu on the form "Y/N"), they dont appear in "Laptop" table dynamic select menu. This would then avoid the Laptops every being Loaned Twice!!!! Any help much apreciated thank you Quote Link to comment Share on other sites More sharing options...
Jessica Posted February 12, 2007 Share Posted February 12, 2007 Add a boolean field to the laptop table called "available" or something. When you loan one, mark it as not-available. Have your select get all WHERE available = 1 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.