Reply to thread

Message: [QUOTE="inungh, post: 2598855"] I have user, activity, element and user template four tables. user table has following fields user id, user name, user code, user rights..... actitivy table has following fields activity id, activty code, activity name, actiivty description, Element table has following fields Element id, element code, element name, element description, and I am design user template to let user fill the information from user template table base on user creates the combination of activity and element the relationship between activity and element is many to many. I need have a composite key for user template table which is user id, activity id and element id to get right template base on user's activity and element selection. It seems that I need use the middle table of activity and element table for their many to many relationship and user template table to link with user table and activity element table. Thanks again for helping, [/QUOTE]