Results 1 to 3 of 3

Thread: Loop Control

  1. #1
    Join Date
    Jan 2003
    Location
    Iran
    Posts
    2

    Unanswered: Loop Control

    Hi Dears;
    I have db in Access 2000.In this db I have a table named "prod_tree" that includes data of some products of my company.The table has parent _ child logic,so each parent may have 0 or more child(s) and itself may be child of 0 or more parents!!!.
    I need a procedure to control any probable loop(s) in this table, so that none of childe(s) and/or child(s) of child(s) of a parent can not appear as its parents.
    The primary key of table are two columns named as " parent_code" and "component_code".I hope I have been explained my problem as clear as possible.

    your faithful Reza

  2. #2
    Join Date
    Oct 2002
    Location
    NSW Australia
    Posts
    61
    You just need to set up your relationships between the tables correctly.

    ie.
    table1 -> table2 = 1 to many
    table2 -> table3 = 1 to many

  3. #3
    Join Date
    Jan 2003
    Location
    Iran
    Posts
    2
    Dear dnofdeath:
    Thank you for your early reply . But the matter happens only in one table , and relationship rules cannot support that,except there will be an interrelationship between a table with itself. I didnot know such capability in Access,but if there was it can only solve a part of problem,and agian we need some module(s) to loop control.
    thanks Reza.

    Originally posted by denofdeath
    You just need to set up your relationships between the tables correctly.

    ie.
    table1 -> table2 = 1 to many
    table2 -> table3 = 1 to many

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •