"Jeg har en tabel1 med felterne id,afdeling,lokalitet og en tabel2 indeholdende lokationer og afdelinger."

So what your saying is the two tables contain the same information?

If I understand the question and the design of your tables correctly then you have no need for lokalitet in tabel1. You have a relationship between tabel1 and table2 on afdeling so you will alwasy be able to find lokation.

I suggest that you alter the design of tabel1 so that the field afdeling is altered so that the data type is Lookup. When you do this you will start a wizard which will help you choose which table you want to "lookup", in this case Tabel2.

http://www.brainbell.com/ (...)

Hej Terry

Du har ret jeg har lavet om på tabellen og lavet et lookup felt som beskrevet i linket fra brainbell. Sender du et svar terry?

svar :o)

thanks