Single field related to many field!

[Questions King]

HI all, what I need to know is can I do it single field related to many field? like:

-In Sales Order Field A(Unit Price)

-In Product Info Field A(Agent Price) Field B(Van Price) Field C(Normal Price)

What I need to do is when I create the new Sales Order, I want to select the diffent type of price from Product Info? can this done? Thank!

[Slobey]

I am not sure you mean a relationship. I assume you have a relationship between the "Sales Order" table and the "Product Info" table. If you have a relationship based on product ID or name (ID is best) then you can have a Pricing field with a value list with the values "Agent Price", "Van Price" and "Normal Price". Your Unit price will be a calculation with a case statement like:

Case(Pricing field = "Agent Price"; Product Info::Field A;

Pricing field = "Van Price"; Product Info::Field B;

Pricing field = "Normal Price"; Product Info::Field C)

When you enter the product and select the Pricing type, the proper price will be automatically entered. Pricing field is whatever you decide to call it.

You can do this for each line item or by the entire Order, however you like.

Hope this helps