I am attempting to use one value in a form to pull another value from a different form. Say I have a list of items on form A. One of the fields is for quality. On form B there is a list of items and a range of qualities prices. I have a field from form A named "Quality" with a range of qualities A,B, and C, and on form B I have three fields named "A,B,C" with a different value for each record.
My problem is I want a field in a query or form to show the value of item 1 using the price guide from form B.
My closest attempt to make it work is to have field with this" Price: [[Quality]]. The first [Quality] would produce either an A,B, or C, which then coupled with the field [A,B,C] on form B would give the value I want. The problem is that Access doesn't understand the [[Quality]] is a two step process like I do.
This is what my query screen looks like is this.
This is my relationship screen.
I really appreciate any help you can offer. Thanks in advance.
My problem is I want a field in a query or form to show the value of item 1 using the price guide from form B.
My closest attempt to make it work is to have field with this" Price: [[Quality]]. The first [Quality] would produce either an A,B, or C, which then coupled with the field [A,B,C] on form B would give the value I want. The problem is that Access doesn't understand the [[Quality]] is a two step process like I do.
This is what my query screen looks like is this.
This is my relationship screen.
I really appreciate any help you can offer. Thanks in advance.