| | |
Expression Builder and using SQL in MS Access
Please support our MS Access and FileMaker Pro advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
•
•
Join Date: Feb 2008
Posts: 1
Reputation:
Solved Threads: 0
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
![]() |
Similar Threads
- 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
| Thread Tools | Search this Thread |





