JobProd.MakeToType field

Hi

Im trying to find where this field is. using the Filed Help, it indicates the field is in the JobProd table but when i add the JobProd into a BAQ, the field is not there…

Where can i find it?

Cant find a related BAQ either… Is there a field search tool?

I don’t know this for sure - but I suspect it’s calculated based on the values in the table. So if Order > 0, it’s MakeToType = ORDER… if it’s TargetJobNum is not empty, MakeToType = JOB… if neither, MakeToType = STOCK. Something like that.

1 Like

Thanks, i was able to work it out with that :slight_smile:

Best