I have 2 tables. one is groups and other is frames.
groups has id, name, owner as columns.
grouppage has id,name and user_id.
users can have group pages. users can edit page if they are owner of the group .Means user_id = owner. Otherwise users can not edit the group page.
Hence i have a public property called can_edit.this is true if user_id = owner.
now i want to connect these 2 table using relational ADO. But how do i do it? because i have to connect the user_id in grouppage table to owner in groups. Neither owner nor group_id are primary keys?
Any solution /ideas
Thanks to all