Pictures in database

[canadiandude007]

Is there a way to insert a picture into a layout? I need to be able to have a different picture appear for each database entry, but I only seem to see how you can insert a single picture for all the entries of a table, but not a different picture for each entry.

Any ideas?

[H.P.]

Did you create a container field to put the pix in?

[Jarvis]

This is real easy.

You will need three fields.

Step 1: Create a text field called STUDENT NAMES

This can be populated by a drop down value list that includes all student names.

Step 2: Create a container field called ALL STUDENT PICTURES

After you have created the container field in Step 2, select the OPTIONS button at the right side of DEFINE FIELDS dialog box.

Select Storage options, and type in the number of images you want to store.

This would be the maximum number of repetitions (images).

Step 3: Create a calculation field called INDIVIDUAL STUDENT PICTURE.

At the bottom left corner of the the "Specify Calculation" dialog box is a menu box that says "Calculation result is.......". Click here and select CONTAINER.

The calculation will read something like this:

Case (

STUDENT NAME="BillyBob" ; GetRepetition ( ALL STUDENT PICTURES; 1);

STUDENT NAME="Skippy" ; GetRepetition ( ALL STUDENT PICTURES; 2);

STUDENT NAME="Zorro" ; GetRepetition ( ALL STUDENT PICTURES; 3);

)

When you select "Billy Bob" you get his smiling visage, etc.

The front end administration of this file is pretty simple.

You select the field ALL STUDENT PICTURES and sequentially insert an image into each container field repetition. I like to keep this global container field on its only layout so that my primary layout just contains the fields STUDENT NAME and INDIVIDUAL STUDENT PICTURE.

Hope this helps.

Jarvis

[Scott Quiring]

I don't see why you would need all this structure.

Simply create a container field and place it on the layout.

[canadiandude007]

Thanks SO much, the container field worked like a charm!