creating a many to many relationship

[cissilya]

I need someones help i need to creat a database that has a many to many relationship, and for some reason it wont work. Does anyone have any suggestions?

 

[KornGeek]

Can you elaborate on this? What did you try? What isn't working about it?

 

[lespaul]

have you read the document in the link below?


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[cissilya]

well this is the first really big project that i have created, the back end is laying on a oracle database and the front is in access. There is a main form where you input the project information. then there is a subform where you put in the contact information. The contacts can be connected to more than one project and there can be more than one contact per project.

 

[lespaul]

first you should get the data structure built properly before building/designing forms. Did you read the document? It's the main basic reference for table structuring.

Can you tell us about the tables you've already created, what relationships you are trying to design and how they are not working?

 

[cissilya]

Yes i read that doc, and it did help basically i have a project table, and a contact table after i created the xref table which is the many to many table link it does not insert the records.

 

[lespaul]

do you have some kind of event triggered to do the insert?

 

[cissilya]

no i think that is what i am missing, i do have some triggers in oracle but have never put them on access. if you could stear me in the right direction that would be great