Dynamically linking fields to container field repetitions

[Jarvis]

I have a database for my cabinetshop that makes use of container fields with repetitions.

Based upon the cabinet style you select the image will change on the record.

Each cabinet has salient data that describes it.

I would like to have these fields dynamically related to the container field.

If, for example, the repetition calls graphic 1, I would like all three fields to show up. If the repetition contains graphic 2 I would like just the two fields to present themselves.

[color:red]Is there a way to dynamically link these fields to particular container field results?

Edited October 25, 2009 by Guest

[Vaughan]

It would be a lot easier if the graphics were in separate records, and not repeating fields.

The easiest way to get the data into separate records is to import into a new table, and select the option to put repeating fields into separate records. Then create the necessary primary and foreign fields needed to link the graphics records to the master record. Use a portal to allow the display of multiple images.

[Jarvis]

Vaughn,

I've been off the computer for several days and I just now saw your response.

I was not aware that I could put repeating fields into separate records. I will look into that. At first blush this seems like it would add a whole new dimension to what I am trying to accomplish.

Thanks so much!

Jarvis