Jump to content

finding variable fields


WC Howard
 Share

This topic is 5746 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Greetings!

I have four files related for a purchase order scheme; line items, orders, vendors and products. The whole thing works well except for one thing, and that is the vendor part number. Each vendor's part number is stored in the products file under their own field, and I can't figure out how to get FM (6 Dev. now, upgrading to 8.5 soon) to find the right field for line items file to make the print out and/or export for Excel.

The match field in Line Items to Products is the company part number, and is used to get the field "product" (describing what the product is, such as "nail" or "clock"). My problem here is so many vendors and getting is to read from the matching vendor's field.

I've tried to create a calculation for a calculation (Products:???(Orders::Vendor)), but so far haven't been able to figure out how to get the right field to display. The calculation box won't let me do this kind of calculation.

Anybody have an idea?

Link to comment
Share on other sites

This may be the way, but I need a little help in understanding it (and I do thank you for sending that file, it does indeed give ideas)... What is the "vertical" character you keep using and what is it's function, and, I don't understand the paragraph character in the one calculation... could you please elaborate?

I had to look up the meaning of the Case function, something I'd never used before...

Link to comment
Share on other sites

This topic is 5746 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.