Database Question

[thinboy]

Hi can someone help me with a scenario i am having trouble with, i have made the database, but its not complete i was just wondering whether some one could help m

Thanks

[MMcCarthy]

Hi can someone help me with a scenario i am having trouble with, i have made the database, but its not complete i was just wondering whether some one could help m

Thanks

Describe your problem and we'll see if we can help.

Mary

[thinboy]

Hi i have made the database so far but i need help with the Reservations table and also some forms and querys.

[MMcCarthy]

Hi i have made the database so far but i need help with the Reservations table and also some forms and querys.

If you want help you will have to explain in detail what is wrong. Lets just start with the table. Can you post the metadata of the table and tell us what is wrong.

Here is an example of how to post table MetaData :
Table Name=tblBookings

Field; Type; IndexInfo
StudentID; Autonumber; PK
Family; String; FK
Name; String
University; String; FK
Mark; Numeric
LastAttendance; Date/Time

Mary

[thinboy]

Hi Mary,

This is my ERD

Member 1:N Copy N : Video 1: N Reservations N : 1 Member

[MMcCarthy]

Hi Mary,

This is my ERD

Member 1:N Copy N : Video 1: N Reservations N : 1 Member

What's the relationship between Copy and Video?

Please follow the format I gave you as it gives me a better image of the structure.

Mary

[thinboy]

Hi Mary the relationship between Copy and Video is Many Copies to One Video

Thanks

[MMcCarthy]

Hi Mary the relationship between Copy and Video is Many Copies to One Video

Thanks

I still need them in the format I asked for and I also need you to tell me what the problem is.

Mary

[NeoPa]

Hi Mary the relationship between Copy and Video is Many Copies to One Video

Thanks

ThinBoy, You need to provide the information requested otherwise how can you expect a sensible answer?
This question is akin to asking :
"I have a problem. What's the solution?"
If you can't see why that would be a difficult question to answer then you need to stop and think for a bit.