undgå sammenkædet tabeller mellem 3 db'er

Ingolf, why dont you put all your eggs in one basket? (same dB)
I am guessing that you are using three dB's for different applications but that doesnt mean that you cant have the  tables in one dB.
What you could do is link them as you are doing now and then using SQL APPEND the new records to the table in db1

terry
At samle alle 3 db'er i en db er der grunde til at man ikke ønsker, f.ex. har de vidt forskellige funktitoner.
Kan du vise hvordan denne SQL APPEND funktione skulle anvendes?

Ingolf>I am sure the problem could be solved in a number of ways but not knowing the requirements I am just guessing.
I assume that you only want to append those from db2 which do NOT already exist in db1. So first you should make a query (using the unmatched query wizard). Then you can make an append query in the query designer. First choose the table you want to append FROM then in the menu there is a buttin(icon) where you can choose the query type here you choose append query. Then ist just a case of choosing the table you want to append TO. Then in the query choose the fields.

ingolf>do you still need help here?

Jeg har løst problemet med en tillægsforespørgsel. Du får dine point.

Jeg mangler bare at få tillægsforespørgslen til at køre automatisk for hver post i de berørte tabeller der oprettes i db2 og db3. Så har du et forslag til det, er du velkommen med løsningen.

Doesnt the "tillægsforespørgsel" take ALL records at once?

terry
Tillægsforespørgslen tager kun alle records med hvis ikke du opsætter kriterier i forespørgslen.
Oprettes der nøglerfelter i destinationstabellen undgåes der dubletter her.