Reply to thread

Message: [QUOTE="inungh, post: 2598853"] Thanks for the message, Child table has 3 keys fields, but only one key field in the parent table. Yes, there are multi records in child table relate to parent table. This is what I guess that I am not in the right direction. It will too long to expalin the business rules here. In short, parent table is tbluser which key is UserID Child table is a User Template to fill the activity when user enter. The problem is the activity (ActivityID) has one child called element (ElementID) If I want to have the user template table to have element level then my user template table must be UserID, ActivityID and ElementID, but without middle table which has UserID and ActivityId, Thanks again for helping, [/QUOTE]