you could have a genre field then do a query looking up all horror movies?
Printable View
I HATE ACCESS LOL.
the relationships is the easy part
im going forms atm
its easy, but y cant it just not be in a spreadsheet LOL.
yeaa i know what you mean
i ask my teacher for help every 2 mins, no joke lmao.
Oo I think it's coming back to me :S
I have wrote:
Tbl_customers
Customer ID - Autonumber
First Name - Text
Last Name - Text
Tbl_DVD
dvdID - Autonumber
DVD Title - Text
Genre - Text
Tbl_rental
Order number - ? Unsure whether it is autonumber or not.
Order date - Time and date
customer ID - Lookup wizard?
DVD ID - Lookup wizard?
I think that's like.. right?
:P
Then for relationships I have to split it all up or w.e :D
Tbl_customers
Customer ID - Autonumber [Primary key]
First Name - Text - Field size 4 - Validation rule: 'Mr' or 'Mrs' or 'Miss' or 'Ms' - combo box ( Mr;Mrs;Miss;Ms )
Last Name - Text - field size 30
Tbl_DVD
dvdID - Autonumber [Primary Key]
DVD Title - Text - Field size 100
Genre - Text - Field size 50
Tbl_rental
Order number - number
Order date - Time and date
customer ID - Lookup wizard
DVD ID - Lookup wizard
okay I love you :D
I don't think we have done validation box's tbh, + I'm not sure if we have really doe much about field size. But I love you for helping me anyways :D
I can just take in what I have done and show the teacher tomorrow + see if I have done it right or not :D
again, THANKYOU!