To the experts. .
I have a proditem1 table and proditem2 table and a join table called prod_join1_item (. . .all linked just like I learned in TasTrade ordentry) In my productadd.scx I added these three to the data envoriment, dragged and dropped the indexes accordingly and put them on the form. . .that portion works fine, adding/changing/delete within the parent table or child table.
Next I set up a join table prod_join2_item2 to third table proditem3 joining with proditem2. . that portion works fine but gives me not the results I am looking for. . .it gives one item in prodtitem1 and many items in proditem3. . .
What I am trying to do, is 1 item in proditem1 with 1 or many items in proditem2 and with 1 or many items in proditem3. . .(proditem3 not just dependant on proditem2 but also on proditem1. . .)
I there a way to accomplish this?
Deeply appreciate any feedback.
THX
Bill
I have a proditem1 table and proditem2 table and a join table called prod_join1_item (. . .all linked just like I learned in TasTrade ordentry) In my productadd.scx I added these three to the data envoriment, dragged and dropped the indexes accordingly and put them on the form. . .that portion works fine, adding/changing/delete within the parent table or child table.
Next I set up a join table prod_join2_item2 to third table proditem3 joining with proditem2. . that portion works fine but gives me not the results I am looking for. . .it gives one item in prodtitem1 and many items in proditem3. . .
What I am trying to do, is 1 item in proditem1 with 1 or many items in proditem2 and with 1 or many items in proditem3. . .(proditem3 not just dependant on proditem2 but also on proditem1. . .)
I there a way to accomplish this?
Deeply appreciate any feedback.
THX
Bill
