Referencing multiple Cells to one cell [Closed]

Report
-
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
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

Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
215
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!