Tables and Subdatasheets

[anilvaghela]

Hello! First of all i am a newbie here!

Ok lets get started.....

I have created a database which is a reference database for my work.

I am now stuck and require help in sorting out the problem i am facing.

Ok.....

I have 6 tables.

tbl_level1, tbl_level2 and so on till u get to tbl_level6.

each table has a unique_id and a parent_id so from tbl_level6 going upwards the parent_id from level 6 is linked to the unique_id from level5 and so on.

This then creates a group of different data from level 1 and sorts out the rest when u go downwards.....

As this data is shown as subdatasheets..... i cannot get the layout of this data all into one table. my logic is to write some code to append first row from level_1 then take the unique_id from level 1 and search for these records in parent_id from level 2 and append them and so on..... then loop back to level 1..............

My question is how do i do this?

Please help!

Thanks!!!

 

[wazz]

append first row from level_1 then take the unique_id from level 1 and search for these records in parent_id from level 2 and append them and so on

if you've just appended to level 1 you won't find level1ID in level 2 or anywhere else.

 

[anilvaghela]

Thanks for this.... but how do i automate this to search the records in level 2....

 

[anilvaghela]

i have added a screen shot of the subdatasheet which is expanded on some rows from level 1..... as u can see u_id is linked to the parent_u_id which does not show on the lower tables but i want it to append them all in this layout.....

 

[anilvaghela]

Here is an excel view of the layout of the data..... it must be in this order..... basically on the excel sheet i have placed the names and how they must sit under each level like a tree view.....

basically take the first one....VISION that row will append first... then from Level 1 it will be CHILDREN that must get appended...BUT if you look there are more groups within level 1 on a database sheet but i need to exclude them from being appended and go to level 2 and first append CBBC then append anything within LEVEL 3 belonging to CBBC..... BUT then i need it to be clever and state if there is anything else within level 2 which is belonging to CHILDREN to append this as there is Cbeebies... and so on..... have a look at the excel sheet....