Part Inspection Required

[tmayfield (Tammy Mayfield)]

I am trying to write a dashboard if inspection required is set on a part. seems easy enough, there is a drop-down to set the if inspection is required. Yay!

This field is bound to Part.RcvInspectionReqPart. I set that to part 1099-2-0 but when I look in the database this field is a 0.

How do I tell when inspection required is set?

[jkane (John Kane)]

Are you using the partplant table?

[bruce6s (Bruce Crile)]

Try this field, PartPlant_RcvInspectionReqPart

[tmayfield (Tammy Mayfield)]

Yay, its set there. You would think that if it shows bound to a field it would update that field.

[JasonMcD (Jason McDermott)]

@tmayfield

You would think that if it shows bound to a field it would update that field.

Not exactly the same, but I know what you mean:

PSA: Checkboxes that actually are string or integer fields in a completely different table

TL;DR: Screen Subsection Checkbox in UI Actual DB field Type Supplier Price List Supplier Parts Primary Supplier PartPlant.VendorNum int Buyer System Default XaSyst.SysBuyerID string Buyer Authorized User List Default Buyer UserComp.PrimBuyerID string Work Force Authorized User List DefaultUser UserComp.PrimSalesRepID string Job Entry Operation > Scheduling Factors Final Operation JobAsmbl.FinalOpr int Job Entry Operation > Scheduling Factors Auto Receive JobAsmbl.AutoRecOpr i…

(Wow that is ugly as a preview. It’s a nice chart if you go to the post.)