Announcement

Collapse
No announcement yet.

Synchronizing two tables with N-N relation

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Synchronizing two tables with N-N relation

    Hello everyone:

    I need a menu tree to the left so that when you select a node in another application show me records that contain the option that the user selected.

    With the help of the forum I have synchronized two forms in a container application but the tables have a 1-N relation.

    The detail is that the selected node is related by a relation N - N to the table the other application.

    I have tried using WHERE statements EXIST (... or WHERE "variable" IN (... in the SQL section of a form, but I always get the error.

    Is posible that I can combine multiple SQL SELECT statements in the section of a form?

    thanks

  • #2
    Under which database?? In oracle you have a CONNECT BY with which you can represent trees.
    For mysql you could check this: http://mikehillyer.com/articles/mana...data-in-mysql/
    There is a whole book written on this subject "Joe Celko's Trees and Hierarchies in SQL for smarties" is the title. Maybe that will give you some extra info.

    Comment

    Working...
    X