Referencing multiple Cells to one cell

Closed
Parish - Jun 2, 2009 at 11:09 AM
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
- Jun 3, 2009 at 12:25 AM
Hello,

I have a table of values that i have screenshott here, for you: http://tinypic.com/images/goodbye.jpg

I also have what resembles a query form, which i have screenshott for you, again: http://tinypic.com/images/goodbye.jpg

The person would simply alter the values under name / size / color on the query form, which would generate the "Product ID" (AAA in the screenshot), which would then generate the availability of the product (in the form of in or out of stock) as well as the price of said product.

So for example, if i was to edit:

Name / Size / Color
A / B / A

Then the Product ID would be automatically generated to ABA. And the availability of product ABA and it's cost would be generated.

or, if i was to;

Name / Size / Color
A / C / B

Then the Product ID would be automatically generated to ACB. And the availability of product ACB and it's cost would be generated.

Thanks for any help in advance.

1 reply

mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
159
Jun 3, 2009 at 12:25 AM
Sorry my organization have blocked many sites and this http://tinypic.com/images/goodbye.jpg is also blocked. can't see what actually you require ......


1