Hi All,

I have an association table with 3 columns (primarykeyId, foreign key to Table1, foreign key to Table2). I am thinking to have a child table pointing to this association table. The association table will have additions and deletions for new associations. Now the new child table will also be affected. Please note this new child table will have parent-child relationship with itself.

Is it a good design or could there be a better design possible?

Thank you,
Hussain

1- Rename your entites may we can expect the relation and imagine the design....
2- Attach yours to let us help you better.

I agree with Ramy.

The way your question is worded the only answer we can give is MAYBE. :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.