Annoying thing is.. If I was on a computer with MS access I could probably do it.
Just it's confusing having to write it down
+ Im basically like :S on how to link up to say they like horror - Show them all horror movies
I think it will be easier if I draw the realtionships first..
so I think it will looksomething like this:
Probably wrong titles Já + obviously have more titles etc. But I think that's right "/
you could have a genre field then do a query looking up all horror movies?
Danielle
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?
Then for relationships I have to split it all up or w.e
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?
Then for relationships I have to split it all up or w.e
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
Danielle
okay I love youTbl_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
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
I can just take in what I have done and show the teacher tomorrow + see if I have done it right or not
again, THANKYOU!
ehhe bye have a good day tomorrowokay I love you
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
I can just take in what I have done and show the teacher tomorrow + see if I have done it right or not
again, THANKYOU!
xo
Danielle
Want to hide these adverts? Register an account for free!