•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 374,176 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,442 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser:
Views: 1163 | Replies: 0
 |
•
•
Join Date: Feb 2008
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
First hello to every one in this forum.
Well I am using MS Access 2003 for building a database.
I am usign 3 tables.
Both student and books table has one to many relation with request table.
I am using MS Access Forum for all tables.
Now when I use Request table to issue a book to a student every thing goes
fine but the problem is that.
" When a book is issued to a student ,there is a field name "Avalibility" in
Books table which should show unavalible when book is issued. [By default
it is set to avalible]
Kindly tell me how to do this ?
Full view of relationship is as follows:
http://img2.freeimagehosting.net/ima...d43d71cb6c.jpg
Well I am using MS Access 2003 for building a database.
I am usign 3 tables.
- Students
- Books
- Request
Both student and books table has one to many relation with request table.
I am using MS Access Forum for all tables.
Now when I use Request table to issue a book to a student every thing goes
fine but the problem is that.
" When a book is issued to a student ,there is a field name "Avalibility" in
Books table which should show unavalible when book is issued. [By default
it is set to avalible]
Kindly tell me how to do this ?
Full view of relationship is as follows:
http://img2.freeimagehosting.net/ima...d43d71cb6c.jpg
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS Access and FileMaker Pro Marketplace
Linear Mode
•
•
•
•
access ajax asp code combo data database decimal seperator thousand seperator when using sql server deleting records from ms sql table where columns have duplicate values developer development dropdownlist hacker ip management studio 2005 microshaft microsoft module ms msdn net news office reuse security software sql sql cache dependency with polling-based invalidation survey vista web
- acess database help!!! pls.... (MS Access and FileMaker Pro)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: packaging mde for distribution.
- Next Thread: Access List boxes
