Kunde database, med scans

Start med at lave tabellen "kunder" med diverse informationer f.eks.:
KundeID      (Primærnøgle, Autonum)
Kundenavn    (Tekst)
Kundeadresse  (Tekst)
Kundepostnr  (Tal)
Kundeby      (Tekst)
KundePrvtlf  (Tekst)
KundeArbtlf  (Tekst)

Dernæst opretter du en tabel "Scans" med følgende felter :
ScanID    (Primærnøgle, Autonum)
KundeID  (Tal)
Filnavn  (Tekst)

Så laver du en 1-n relation mellem kunder.kundeID og Scans.KundeID

You will need to scan your "stykke papir" with another programthan Access, normally you get one with the scanner. Then you can brows to this file and put the path/filename in a table. Larsen's idea seems OK.

You can also take a look at this article for information as to how you can display the file http://www.eksperten.dk/artikler/197

Normally you will only store the path/filename of th efile and NOT the actual file, these fil far too much in the dB.

You can use the file open dialog to browse to the file. Or you can use this exampele.
http://www.mvps.org/access/api/api0001.htm

And I think ThomasJepsen has a demo database you could look at.
http://www.makeiteasy.dk/eksempler/OpenFileDialog.zip

programthan = program than