Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Read 1-M form table frame records individually to process if statement

Status
Not open for further replies.

PBSLinda

Programmer
Dec 13, 2000
6
US
What is the most efficient way to read all records in a table frame on a form. Form with a parent & child (1 to many)tables. Child is setup as a table frame(QITable) with multiple records(QIRecord). Based on the production step field(QIStep), I want to accumulate information in various total fields. QIStep can contain multiples of the same type. example: QIStep = Angle, 3 different records because of 3 different sizes (Size part of key). example of data: Angle, size1, $10; Angle, size2, $8; Angle, size3, $6; Cut, size1, $5; Cut, size2, $4; Hole, size1, $3. I need to total all Angles, all Cuts, all Holes displayed in child tableframe. I cna't use a sum field because it totals Angles, Cuts and Holes as one total.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top