GTRR or not

[paulmild]

I have 3 tables with fields (amongst others) as follows -

 

Jobs - PK_JobID

 

Delivery Notes - PK_DelNoteID

 

Delivery Note Line Items - PK_LineItemID, FK_JobID, FK_DelNoteID

 

Delivery notes are compiled on a layout (L1) based on the Delivery Note table with a portal of related line items

 

I also have a Delivery Note layout (L2) for printing based on the Line Items table.

 

From L1 I can script GTRR and open L2 with the correct details.

 

What I want to be able to do is open L2 from a layout based on the Jobs table.

 

From a jobs table layout I can successfully script GTRR and open L1 with correct details - and can then GTRR and open L2.

 

What would be a more efficient way of moving directly to the layout based on the Line Items table.

 

Thanks

[Fitch]

You have FK_JobID in Line Items, so you could make a relationship Jobs to Line Items and GTRR using that.

[Wim Decorte]

Or you can just go do a find in L2...

[paulmild]

Fitch

 

I tried that but Job to Line Item is 1:1 so on the layout based on the Line Items table I get a single line (Job).

 

Wim

 

I can set a global/variable to be FK_DelNoteID for the line item so I guess I need to use this in a find.

[paulmild]

Thanks, the Find sorted it, for some reason I was obssessing on GTRR