Default Value Question (1 Viewer)

[Hydra427]

I have a table for pictures of cars where I am setting up the default value to be "C:/mypictures/cars/buick.jpg"

Can I have the default value automatically import the cars ID field & NUMBER field

As an example the buick is ID = 123 and the NUMBER is 01A

I was thinking of something like this but it doesn't work the way is was thinking "C:/mypictures/cars/[ID][NUMBER]buick.jpg" which would return this into the database "C:/mypictures/cars/12301Abuick.jpg"

Any help would be greatly appreciated.

Thanks, John

 

[Isskint]

John, hi

Couple bits of clarification if you could?

This car pictures table, is this purely for storing file paths that will be referenced in other tables?

Why would you want/need to have the default value automatically import the cars ID field & NUMBER field? and what do you mean by this?


As a rule i have a table that will store the file path to images. it will have an ID (unique), description and file path fields. Then in any table where i want to use one of the pictures i reference the ID number. On a form/report lookup the path via the ID no.