469,631 Members | 1,526 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,631 developers. It's quick & easy.

Files and Status/Location Keys

I am working on a project for a law firm where the different files are either boxed or unboxed. Unboxed files can be on a lawyer's desk, on the secretary's desk, or on a shelf in the back room.

A file which is Boxed must have the same status and location of its assigned box. If the box’s status or location changes, the status or location of any boxed files must be changed as well. This should happen automatically. A file which is not boxed may have a different status and location from that of its assigned box; however the status and location must not be offsite. All Offsite files must be boxed.

Box Table

Box Key PK
Box ID
Box Destroy Yes/no (has the box been destroyed)
Box Status FK
Box Location FK

Location Table

Location ID FK
Location Description Text

Status Table

Status_ID_FK
Status Name Text
Status Description Text

File Table (refers to items within a clients file folder)

File ID
File Number
File Description
File Boxed Y/N
File Destroy Y/N
Client Number (linked to number in client table)
File Status FK
File Location FK
Box Key

Any help y'all can give me would be appreciated.

steve
Aug 22 '07 #1
3 1462
Rabbit
12,516 Expert Mod 8TB
So what is the problem exactly?
Aug 22 '07 #2
JKing
1,206 Expert 1GB
My first thought is to turn on cascade updates. Though without fully understanding the system this may causes issues...

From my understanding all files will at one time or another be in a box. If the file has been removed from the box it is flagged as such. A file is removed because it is in use. Upon moving a box any files that are currently in the box should have their location and status updated to match that of the box that they are in.

Because of this condition I dont believe you'd be able to cascade updates but rather you'd need a trigger to fire off on the afterupdate of the box table. If you're doing direct table manipulation I'm not sure if this is possible. If you're using forms I would suggest coding an after update event on the box form that will update the files table for those files in the moved box.
Aug 22 '07 #3
My first thought is to turn on cascade updates. Though without fully understanding the system this may causes issues...

From my understanding all files will at one time or another be in a box. If the file has been removed from the box it is flagged as such. A file is removed because it is in use. Upon moving a box any files that are currently in the box should have their location and status updated to match that of the box that they are in.

Because of this condition I dont believe you'd be able to cascade updates but rather you'd need a trigger to fire off on the afterupdate of the box table. If you're doing direct table manipulation I'm not sure if this is possible. If you're using forms I would suggest coding an after update event on the box form that will update the files table for those files in the moved box.
Elegant. Thank you. This is my first Access project since getting my MS certification and I'm learning just how much stuff was not covered in the course.
Aug 22 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by KennethBohman | last post: by
1 post views Thread by Scott Davies | last post: by
reply views Thread by Scott Davies | last post: by
5 posts views Thread by Boni | last post: by
3 posts views Thread by Steve Teeples | last post: by
18 posts views Thread by mistral | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.