gstylianou
Registered User.
- Local time
- Today, 22:23
- Joined
- Dec 16, 2013
- Messages
- 357
Hi,
Attached there is a file for better understanding on what exactly I should do:
In my database there are two tables, the Table1 (Master Table) and the Table2 (Child Table). Usually i have new records form one external file (accdb) which are included into Table2.
What i must to do is the following:
1. The Table1 has one autonuber field and another one field with the ID of each record.
2. Because the Table2 is imported from another (external) database with a different design architecture, etc., does not include the ID needed in the Table1, Therefore it cannot append the new records into Table1 without this ID. As a result of this issue i must use other methods (such as ecxell) in oder to give the appropriate ID numbers for the field [ID] into Table1.
So, what i need is to modify the append query so to give directly the [ID +1] based on last number into ID field.
I tried to put an expresion field into the append query to give the corect numbers for the [ID] field (+1) without any results..!
I would apprechieate any help
Thanks in advance
Attached there is a file for better understanding on what exactly I should do:
In my database there are two tables, the Table1 (Master Table) and the Table2 (Child Table). Usually i have new records form one external file (accdb) which are included into Table2.
What i must to do is the following:
1. The Table1 has one autonuber field and another one field with the ID of each record.
2. Because the Table2 is imported from another (external) database with a different design architecture, etc., does not include the ID needed in the Table1, Therefore it cannot append the new records into Table1 without this ID. As a result of this issue i must use other methods (such as ecxell) in oder to give the appropriate ID numbers for the field [ID] into Table1.
So, what i need is to modify the append query so to give directly the [ID +1] based on last number into ID field.
I tried to put an expresion field into the append query to give the corect numbers for the [ID] field (+1) without any results..!
I would apprechieate any help
Thanks in advance