create product tree

[Guest]

Sorry I have a long question.
I want a product tree with parts no and serial no.
First I crate a table that contains part no, serial no, next part no, next
serial no, level of that part and other properties. Then I create queries per
level. (level 1 top assemby, 2 next subpart, ...) Then create forms whose
data come from that queries. Finally linked the forms to each other as
subforms. Main form from query whose level is 1, next 2,.... Form looks good
but I cannot edit that form, cannot add, delete, or change anything. I have
to go table. What may be the reaon. Or is there any easy method to make this
operation. I have to enter two records for an item to work this. one as part
no & serial no, other as next part no & next serial no.)
Thank you.

 

[Vincent Johns]

From what you say, my guess is that part of the problem may relate to
what is sometimes called a "repeating group" -- you have several fields
in the [Parts] Table that contain the same kind of information. In your
Table, what is in [next part no]? If it's the same kind of information
as in [part no], just for a different part or subassembly, then I
suggest replacing it with maybe two other fields, both of which contain
keys to the [Parts] Table rather than data: [First subpart] and [Next
part on this level]. The [Next part on this level] field of the Level 1
top assembly would probably have a null value, but on the subassemblies,
the chain of [Next part on this level] fields would give you a list of
all the next-level component parts. The [First subpart] field would
take you down a level, but in records at the bottom level it would have
a null value.

Not all Queries are updateable. If your Query Datasheet View doesn't
let you add records at the end, you probably have the read-only variety.

If you could post some sample records from your Table, the SQL of the
Queries that are giving you trouble, and a list of what output you'd
like to see generated from your sample records, we could give you a more
specific answer.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.