msdn tutorial - access question

[joser]

I tried following tutorial,

http://msdn2.microsoft.com/en-us/lib...US,VS.80).aspx

and my question is:
What property in msaccess causes making the relation between customers and orders tables when I drag and drop tables from data source window?

I tried to make same type of database, but couldnt make it happend. Also tried to ad and modify relation in .xsd file.

[gigemboy]

You have to make sure you specify your primary keys, and your relationships... You have to create a relationship between the field in one table in relation to the field in the other table, Like in Orders Table, you probably have a field that lists the customer ID, that is also located in the Customer Table, a 1-to-many relationship. Search google for "Access Table relationships" or something in order to find some examples...

[joser]

Yes, that was what i was thinking, but didn't find right words. Thanks very much!