Problem in Switching Import table to Link table

[kelvin24]

i am using pervasive database. first i imported the tables to test my query and it worked out ok. But now i want to use link table instead to have the updated data. so i delete the imported table and create a link table with the same name, but it is not showing anything now in the query.
please help me find out thank you.

kelvin

 

[kelvin24]

oh i here is my query, i am trying to do a bom report.

SELECT BMPRDSTR.PARENT_ITEM_NO AS Level1Parent, BMPRDSTR.COMPONENT_ITEM_NO AS Level1Component, BMPRDSTR.QTY_PER_PARENT AS Level1QTY_PER_PARENT, BMPRDSTR.SEQUENCE_NO AS Level1SEQ, BMPRDSTR_1.PARENT_ITEM_NO AS Level2Parent, BMPRDSTR_1.COMPONENT_ITEM_NO AS Level2Component, BMPRDSTR_1.QTY_PER_PARENT AS Level2QTY_PER_PARENT, BMPRDSTR_1.SEQUENCE_NO AS Level2SEQ, BMPRDSTR_2.PARENT_ITEM_NO AS Level3Parent, BMPRDSTR_2.COMPONENT_ITEM_NO AS Level3Component, BMPRDSTR_2.QTY_PER_PARENT AS Level3QTY_PER_PARENT, BMPRDSTR_2.SEQUENCE_NO AS Level3SEQ, BMPRDSTR_3.PARENT_ITEM_NO AS Level4Parent, BMPRDSTR_3.COMPONENT_ITEM_NO AS Level4Component, BMPRDSTR_3.QTY_PER_PARENT AS Level4QTY_PER_PARENT, BMPRDSTR_3.SEQUENCE_NO AS Level4SEQ, BMPRDSTR_4.PARENT_ITEM_NO AS Level5Parent, BMPRDSTR_4.COMPONENT_ITEM_NO AS Level5Component, BMPRDSTR_4.QTY_PER_PARENT AS Level5QTY_PER_PARENT, BMPRDSTR_4.SEQUENCE_NO AS Level5SEQ
FROM (((BMPRDSTR LEFT JOIN BMPRDSTR AS BMPRDSTR_1 ON BMPRDSTR.COMPONENT_ITEM_NO = BMPRDSTR_1.PARENT_ITEM_NO) LEFT JOIN BMPRDSTR AS BMPRDSTR_2 ON BMPRDSTR_1.COMPONENT_ITEM_NO = BMPRDSTR_2.PARENT_ITEM_NO) LEFT JOIN BMPRDSTR AS BMPRDSTR_3 ON BMPRDSTR_2.COMPONENT_ITEM_NO = BMPRDSTR_3.PARENT_ITEM_NO) LEFT JOIN BMPRDSTR AS BMPRDSTR_4 ON BMPRDSTR_3.COMPONENT_ITEM_NO = BMPRDSTR_4.PARENT_ITEM_NO
ORDER BY BMPRDSTR.COMPONENT_ITEM_NO;