Basic? Yes. But mostly it is your inability or unwillingness to provide details.
This is what you have posted:
Code:
Part: F9999
Level Part Number Trace
1 B1234 N1234
2 B1111 N1111
3 B1999 N1021
2 B1921 N0001
1 A1212 N1999
2 A9999 N9882
2 A1011 N5555
That is the results you want?
How is the data stored? ie What is your table structure?
It could be a normalized structure:
Code:
Table Parts
------------
PartID PK Autonumber
PartNumber Text
PartDesc Text
Table Level1
------------
Level1ID PK Autonumber
PartID_FK Long
Level1Number Text
Level1Desc Text
Table Level2
------------
Level2ID PK Autonumber
Level1ID_FK Long
Level2Number Text
Level2Desc Text
Table Level3
------------
Level3ID PK Autonumber
Level2ID_FK Long
Level3Number Text
Level3Desc Text
(All you would need here is a query)
Or it could be in one table:
Code:
Table PartsLevels
------------
PartID PK Autonumber
PartNumber Text
PartDesc Text
Level Integer
LevelNumber Text
LevelDesc Text
(This might need to have some VBA.)
Or your structure could be a combination of the two.
Or you could have devised a totally different structure.
So until you can be specific on the tables/fields, you probably won't get much help in getting a solution.