Help with relationships

[ordidge2]

hello i am setting up a games database and i would like to use relationships to link tables and forms so that i can view games that are in stock and whcih aren't and see when they were rented and due back, i need soem hlep so if any1 can email me or message me back, if u email me put the subject as 'game database help'

thank you so much

 

[Megatron-Lives]

did you get the help you needed?

 

[ordidge2]

no i didnt i have added you on msn for some instant help if your online

 

[Megatron-Lives]

i'm on pretty much all day (11 - 11, GMT-7)

 

[TheToeOfPooh]

I have got something similar which was produced for a training session using a video hire shop scenario. If you want to have a copy (Access2000) get in touch and I will send a zip file.

 

[Abulafia]

i would like to use relationships to link tables and forms

For your information, relationships do not link tables to forms - they are used to ensure a robust structure between your tables and that fields which should be related are properly connected.

Forms should be used to display queried data.