Auto indsæt

Du ligger noget kode ind i formen så indtastning af en værdi
for post-nummer trigger et lilel stykke VB kode der slår
by op og indsætter værdien i dets felt.

Iøvrigt hvis din database er normaliseret vil du kun gemme
postnumme rog så have en tabel med postnummer-by relationen.

IHvis du vælger den løsning kan du evt. stadigvæk vise by når postnummer
er indtastet på samme måde.

You should have two tables one "medlemsKartotek" and anoter "PostNrBy"

In the medlemsKartotek you should only have the PostNr which references the PostNrBy table where the By is.

Hej

Jeg er meget ny inden for brugen af databaser, kan i måske beskrive det lidt mere, tak

If you have these two tables then you make a query which includes all the fields from medlemsKartotek and By from PostNrBy. Then you make a form based on the query, if your relationships are correct you should have a combo where you can choose the PostNr from and when th erecord is created you will see the By appear in th  By field.

Thank you, here are your points

Tak, hope you can get it to work :o)

If you first make the PostNrBy table then when you make the medlemsKartotek table for the PostNr field choose Lookup as the datatype. Now follow the instructions. This will give you a combo box on the form from where you can choose the postnr from