Hello Everyone,
I have a table with part of it's data coming from an Append query.
In next step, some of other columns are needed to be filled upon the basis of what is the existing value in other columns of same table.
1. Attaching an example DB, where tbl_ItemWardrobes is partially appended table alongwith the Field "Doors".
2. Now I need to update "PIID_Doors" in same table on the basis of text value in "Doors".
3. Field "Doors" in tbl_ItemWardrobes and field "PartItemName" in tbl_PartItem are text values and we need them to match them for finding "PIID_Doors" in tbl_PartItem>PartItemID.
4. When i can find out a working method, these updates will be made in a continous form with a button to activate update query of selected records.
I have tried update queries but none of them work probably its the same table we are updating.
Can anyone provide me a solution for this?
Many Thanks in advance.
I have a table with part of it's data coming from an Append query.
In next step, some of other columns are needed to be filled upon the basis of what is the existing value in other columns of same table.
1. Attaching an example DB, where tbl_ItemWardrobes is partially appended table alongwith the Field "Doors".
2. Now I need to update "PIID_Doors" in same table on the basis of text value in "Doors".
3. Field "Doors" in tbl_ItemWardrobes and field "PartItemName" in tbl_PartItem are text values and we need them to match them for finding "PIID_Doors" in tbl_PartItem>PartItemID.
4. When i can find out a working method, these updates will be made in a continous form with a button to activate update query of selected records.
I have tried update queries but none of them work probably its the same table we are updating.
Can anyone provide me a solution for this?
Many Thanks in advance.