Printable View
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.
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...
Yes, that was what i was thinking, but didn't find right words. Thanks very much! :wave: