Home Many to many relation hookup in Delphi
 How do I do a many to many (master-master) relation in Delphi, I cannot find an example. Only dblookups and master-detail which I understand. Like a product can belong to one or more categories. Like this table structure: Product Table ProductId, ProductName CategoryTable CategoryId, CategoryName Relation table ProductId, CategoryId Ideally if you select a record in the product grid the edit of a product in a detail record is started in the right side of the screen. In here you can edit the product properties an ideally you can select via checkboxes one or more categories in a checkbox group/grid. How do you hook this up with TTable of TQuery components? Is there a way? Hope you can help! Sincerely Edward Some more explaination: The goal is like: master [product grid list] Detail [on selected product] property **A** property **B** property **C** property **D** property **Category collection** Category 1 - checked Category 2 - unchecked Category 3 - unchecked Category 4 - checked