I have one table with fields CustomerID(primary key),Lastname,Firstname, Address.
I Have one more table with fields OrderID(Primarykey), CustomerID, Equipment received, Problem.
In the relationships window I included both tables, after that I drag CustomerID from customer table to CustomerID in order table.In the window I chose referential integrity option.
Some times it is creating one-to-many relationship and some times it is creating one-to-one relationship,and sometimes it is giving me an error like can not create relationship because referential integrity failed order table.
On the other hand I have one more tabe like Orderdetails, the fields are OrderID(primarykey same as in order table),Techname, Serviceperformed,Timetaken.
While i am creating relationship between Ordertable and order details table It is giving me one to one relationship but I want One to many Relationship. How Can I create a One to many relationship.
I think I gave Enough information. If need some more detail information feel free to Ask me.