L
Lila
I have two tables. One is a list of furniture, the other a list of fabrics.
The fabric list has pictures of the fabric embedded. When you're in the
furniture list, I created a drop down that looks to the fabric table for it's
values.
So now I have this form that is based on a query that looks at the furniture
list. The query does some cost calculations as well. Everything is working
fine and showing up on the form, except I'd like the picture of the fabric
swatch to show up and change based on what fabric is selected.
I'm not sure if I should try (or even if it's possible) to create some sort
of lookup field in the original table or if this is something a query would
do... or maybe even something on the form.
Any suggestions?
The fabric list has pictures of the fabric embedded. When you're in the
furniture list, I created a drop down that looks to the fabric table for it's
values.
So now I have this form that is based on a query that looks at the furniture
list. The query does some cost calculations as well. Everything is working
fine and showing up on the form, except I'd like the picture of the fabric
swatch to show up and change based on what fabric is selected.
I'm not sure if I should try (or even if it's possible) to create some sort
of lookup field in the original table or if this is something a query would
do... or maybe even something on the form.
Any suggestions?