Hi I need to create database tables to store memo. in the "To" clause user may select individual employee or group of employees (Different groups are already available in database having many to many relationship with employee). i am wondering what should be structure of tables. For simple memo where there are no groups i will have "MemoMasters" and "Memodetails" with memodetail having EmployeeID as foreign key. how could i embed groups in this structure
(I need to store the acknowledgment information of each employee also )
Regards