Recent content by ultragorgon78

Hopefully this file will help... i do not know how to relate table transaction and exhibit. Any advise and help is welcomed. I am still newbie in MS Access and currently using Ms Access 2007.

Maybe i should change PK in Case table. Remove Id Case (Autonumber) and make Case Number (Text - 19 filed size) Primary Key so i will not enter same case number twice...

Thanks for your reply and i'm sorry if i cant explain it better because i'm not so good in English especially to describe something complex like this. English is my second language here :( Actually what i means is exhibits from 1st transaction which is "IN transaction" stored in exhibit...

Currently i have problems with my project. The situation is i want to register new case which has many exhibits and many transactions. A transaction will have several exhibits. So i have three tables: 1. Case ID Case - Auto number Case Number - Text Date - Date/Time Time - Date...

Im a newbie in MS Access. Currently using MS Access 2007 and having some problems with my current and 1st project in db with MS Access. I learnt MS Access from tutorial, reading some forums, and try and error with MS Access templates. Hope all of u can help me with my project. Im from Malaysia...