I am building a database for my cabinetshop.

I have a columnar type layout that lists door sizes.

To make the math easier to understand I have the dimension fields displayed with a graphic representation of the cabinet.

This graphic + dimension is stored in a portal. If the cabinet has two doors a portal with a double door cabinet presents itself.

If the cabinet has one door a portal with a single door cabinet presents itself.

I would like to, however, have both portals show up at same spot on the layout (depending of course on which graphic is appropriate). I have not been able overlay the portals without both views showing up at the same time.

[color:red]Is it possible to have these portals visible (one at a time) at the same location on the layout?

Thanks,

Jarvis

You probably need to use a calculated container field rather than a portal.

I'm not sure how you have set up the portal to display the various images, but it's probably more complicated (and unnecesarily so) than storing the images in a prefs table and calling them through a single calculation field.

Thanks for your input Vaughan.

I've been making use of Container Field Repetitions for many things in my database. As you suggested, a simple calculation displays the image when needed.

What I wanted in this case was to also have field values display with the graphics. This makes it alot easier for the guys in my shop to understand the cabinet math.

I don't have much experience with portals but this is what I was able to come up with.

Jarvis

Test_Portal_Real_Estate.fp7.zip

Try the attached, I think this is what Vaughan was thinking of.

Cabinets.zip