Relational Graph [ allow create / does this look right ]

[imoree]

Hello everyone; Looking for any help on this one;

Having a bit of an issue with Connectiing Lines --> LineOptions-->Options ___Optionstypes.

just wanted to know how to make this much more efficient jumping over to other layouts to create new records that relate accordingly or allow create wherever necessary. I am a bit hesitant for orphans so i need to figure out a delete tree as well Or perhaps just archive all my records in a utility table when necessary.

Issue i have lies when on LinesOptions Table and user is adding option Types & Options

eg. Product Type = Cake

Option Type = Flavor

Option = Pink Champagne.

Now i need to create new LinesOptions record, which in turn sets lineOptions::optionsID to Lines::ID, then

i need to go to layout Optiontypes; create a new record if it does not exist and set option:optionTYpeID to what OptionsTypes::id is. then go back to original layout to add another Product Option Type.

I am collecing via globals from Orders Table.

-any ideas or am i on the right track?

thanks in adv.

-ian