If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
create product tree
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. |
#2
|
|||
|
|||
create product tree
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 Please feel free to quote anything I say here. AhmetDY wrote: 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I create a large family tree? Does it help to use Excel? | EDubuque | New Users | 2 | January 9th, 2006 02:56 AM |
Outlook 2002 Error (Several Installations) | RDBrimmer | General Discussion | 3 | June 29th, 2005 10:40 AM |
Office 2003 installation problem, log file attached.... | Ryan | Setup, Installing & Configuration | 0 | January 20th, 2005 06:57 PM |
Importing into Excel from a Text file | Greg Gates | General Discussion | 1 | September 7th, 2004 01:36 PM |
Create picture catalog from current product codes | Julio C Santiago | General Discussion | 1 | August 28th, 2004 10:13 AM |