Dezirous
Rafi Ahmed
- Local time
- Today, 16:40
- Joined
- Jul 8, 2009
- Messages
- 71
Hi fellows,
Situation:
I have 2 main tables (tblRecords1 and tblRecords2) with sub tables (tblHistory1 and tblHistory2). Both main tables have same structure (means same fields) and same condition with sub tables.
Requirement:
I just want to merge both main tables into one i.e. tblRecords, similarly tblHistory1 + tblHistory2 = tblHistory.
Each record in tblRecords have primary key and have one-to-one relationship with tblHistory.
Problem:
If I transfer tblRecords2 data into tblRecords1 then they must have new IDs in continuation of tblRecords1. But how could I transfer tblHistory2 data into tblHistory1. How to handle their relationship ID?
Situation:
I have 2 main tables (tblRecords1 and tblRecords2) with sub tables (tblHistory1 and tblHistory2). Both main tables have same structure (means same fields) and same condition with sub tables.
Requirement:
I just want to merge both main tables into one i.e. tblRecords, similarly tblHistory1 + tblHistory2 = tblHistory.
Each record in tblRecords have primary key and have one-to-one relationship with tblHistory.
Problem:
If I transfer tblRecords2 data into tblRecords1 then they must have new IDs in continuation of tblRecords1. But how could I transfer tblHistory2 data into tblHistory1. How to handle their relationship ID?