mithani
Registered User.
- Local time
- Tomorrow, 05:33
- Joined
- May 11, 2007
- Messages
- 291
Hi everyone,
What I am looking for is:
Scenario 1
1. Append all records from Table 1 to Table 2.
2. Whenever any record add/edit/delete inTable 1, Table 2 should automatically upate.
Scenario 2
1. How would I append all records from Table 1 to Table 2 where both tables structure are different. Table 1 is a MYOB table and Table 2 is a access database table.
2. What if I need to append selected data from Table 1 to Table 2. Let's say all data between such date.
I appreciate your help.
mithani
What I am looking for is:
Scenario 1
1. Append all records from Table 1 to Table 2.
2. Whenever any record add/edit/delete inTable 1, Table 2 should automatically upate.
Scenario 2
1. How would I append all records from Table 1 to Table 2 where both tables structure are different. Table 1 is a MYOB table and Table 2 is a access database table.
2. What if I need to append selected data from Table 1 to Table 2. Let's say all data between such date.
I appreciate your help.
mithani