Recent content by thinboywide

Hi i need help filling in the reservations table, can someone help, also how do you do forms and query's Thanks Here is my DB

Could someone please help me a simple solution to my problem i have tried filling in my tables but i keep getting told that another field is required when i enter some value's into my database Thanks

Hi could someone then point me in the right direction as i am lost and new to access? Could you by any chance help me with my relationship's and entities to make them correct. Thanks

Hi i have made the database, with the original ERD i had but i keep getting this error message when adding data into my tables " Cannot add or change record because a related record is required in table MEMBER" Could some please help me with this problem Thanks ( I have enclosed the ERD and...

Hi Neil It's an example assignment, thanks could you possible help me as i am really stuck Thanks

Hi Thanks for your help, Could someone if possible build me this database and then i may have a better idea of how it should work, based on the scenario. Or go through what would be involved in each step This was my orginal idea of an ERD and entities in 3rd Normal Form but i was told there...

Hi neilg Thanks for your help, i have done the tables, but need help with the relationship, as i am new to MS Access, so if you could come up with a solution that would be much appericiated Anyway here is the database so far

Hi i need help with a scenario, I have made the database and the tables but i am having trouble with the forms and bits of the realtionhip. here is the scenario Current System The case study is based on the video issue recording system of the Video Library (VL). VL specialises in obscure...

Hi i need help with one of my relationships I need help with linking Member 1: N Reservations the entites are Video (Vcode, VTitle, Date Made, Director, Genre) Copy (CopyNum, Vcode, Due Date) Loan (LoanMemNum, CopyNum, Ldate, In, Out) Member (MemNum, MName, MAddress) Reservation (VCode...

Function and Non Functional Requirements Hi, Thanks for that tutorial, i need a little help on functional and non functional requirements, any help would be much appreciated.

Hi, Im affraid i still need help, as a matter of opinion, which one do you will work Member 1:n Loan n:1 Copy n:1 Video also there is a link from Member 1:n Reservation n:1 Video Or Member 1:n Loan1:n Video 1:n Copy n: 1 Video also there is a link from Member 1:n Reservation n:1 Video...

Hi, In all honesty is it best that from Loan to Video be a n:1 ? Also would this work overall and would it cause any problems when implementing my database? Thanks Alot

Hi i still need help but i need the relationship to be one to many, is this possible? will it cause any problems within my database when it is implemented? Thanks for all your help

Hi, I tried your solution but i still have the problem. Can anyone help?

Hi, Thanks i think that has fixed the problem, Will doing this effect the database at all?