AnsweredAssumed Answered

Noob question - creating a vendors pricelist?

Question asked by RafalKwiatkowski on Aug 16, 2010
Latest reply on Aug 16, 2010 by philmodjunk

Title

Noob question - creating a vendors pricelist?

Post

Hello,

i have a small noob problem.

I wish to create a form for my vendors. Each box or list hase it's own field. The part of the form (in the layout view) should look like this example:

Painting1: <drop-down list> to <second drop-down list> price <edit box (number)>

Painting2: <drop-down list> to <second drop-down list> price <edit box (number)>

Painting3: <drop-down list> to <second drop-down list> price <edit box (number)>

Painting4: <drop-down list> to <second drop-down list> price <edit box (number)>

Painting5: <drop-down list> to <second drop-down list> price <edit box (number)>

Painting6: <drop-down list> to <second drop-down list> price <edit box (number)>

If my vendor #1 fill the form i will get f.e.:

Painting1: White to Black price 10

Painting2: White to Green price 12

Painting3: BLANK to BLANK price BLANK

Painting4: BLANK to BLANK price BLANK

Painting5: BLANK to BLANK price BLANK

Painting6: BLANK to BLANK price BLANK

If my second vendor fill the form i will get f.e.:

Painting1: White to Green price 12

Painting2: White to Black price 10

Painting3: BLANK to BLANK price BLANK

Painting4: BLANK to BLANK price BLANK

Painting5: BLANK to BLANK price BLANK

Painting6: BLANK to BLANK price BLANK

The problem is that if i search the database i write in the first line (Painting1) that i am looking for White to Black price ≤10 and i get only one result instead of two.

First of all, the price should be attributed to the colors combination not to line and second thing is that when i search for the color combination i should get results from all lines.

How to perform such thing? If my decription isn't clear please let me know.

Regards,

Rafal

Outcomes