You need to create three tables. Table1 will contain 1000 records
Table2 should related to Table1 as many-to-one and Table3 that will relate to
Table2 as many-to-one

Something like this:

Table1

id Autonumber
Desc Text 50


Table2

id Autonumber
table1_ID Longint
Desc Text 50


Table3
id Autonumber
table2_ID Longint
Desc Text 50


Table two will contain 8 records (or however many) for every one in Table1 and
Tabl3 will contain 10 records (or however many) for every one in Table2

Then you will run two queries. Let's Assume that the selected id from Table1
will be equal to 5 then

1. Select * from table2 where table1_ID = 5

2. Select * from Table3 where Table2_ID in (Select ID from table2 where
table1_ID = 5)

Display the result of the first query in one Grid and second query in another
grid


--- In VisualBasic_Official@yahoogroups.com, "mary369_99" <honeypot4u@...>
wrote:
>
> Hi
>
> I want to generate 4 sets of numbers with relationships. First set will have
+- 1000, second set about 8000 and the third about 600 000. This will then be
saved to the database. When selecting a number in the third list, I want to be
able to see it's parent in the first group etc. This is for a store Room System
>
> Every number in the first group, will have 8 children in the second group, and
50 children in the third group.
>
> How can I accomplish the task?
>
> I am using VS 2005.
>
> Regards
>