Derived Field

G

Garret

I'd like to insert a derived field into this situation

tblShipments (Parent table)
Shipment_No
Shipment_Size

tblShipment_Inspection (Child table)
Shipment_No (connected field)
Item_Dimension (The part of the item being
inspected to see if it is "good")
Number_Out_Tolerance (number of items in the shipment that
are bad for this dimension)

I'd like to create the field "Der_Percent_Good" that calculates the
percentage of good items in the shipment.
(1 - Number_Out_Tolerance/Shipment_Size)*100.

How would I do this since the tables are related by Shipment_No, but
the actual size of the shipment is in the parent table but the derived
field would be in the child table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Derived Field 0
A Derived Field 8
Derived Field 0
Help setting up relationship 21
No Field Edit capability 3
side-by-side Child & Grandchild lists 2
Need Suggestions to Eliminate Unplanned Table Behavior 4
How to show checkbox in combobox? 2

Top