T
turkey
i have a table with all the parts that go into making a frame. the completed
frame is made from x and y. x and y have their own record. x is made from a
and b and c--y is made from f and g and h. so on and so forth. some
components are parts, others are subassemblies. (the fields are the "make
from" ) is there a way to call out the completed frame and access goes to
the first field then searches the same table for that record then lists it
"make froms". then it goes to the second field of the completed frame and
does the same thing . having at the end like a huge tree diagram? if this
will even work, i don't know how to do it. thank you so much and have a
great day
--
frame is made from x and y. x and y have their own record. x is made from a
and b and c--y is made from f and g and h. so on and so forth. some
components are parts, others are subassemblies. (the fields are the "make
from" ) is there a way to call out the completed frame and access goes to
the first field then searches the same table for that record then lists it
"make froms". then it goes to the second field of the completed frame and
does the same thing . having at the end like a huge tree diagram? if this
will even work, i don't know how to do it. thank you so much and have a
great day
--