feltopslag i anden tabel med parametre

"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/tutorials/ms-office/Access_2003/Creating_A_Lookup_Field.htm

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