AnsweredAssumed Answered

Multi-Predicate relationship from multiple tabels

Question asked by tmckibbin on Jan 4, 2016
Latest reply on Jan 5, 2016 by tmckibbin

I have a internal time and equipment tracking solution.  I'm a little shaky on multi-predicate relationships.

I have tables called:

TimeCards

Transactions

Billing

 

TimeCards contains all charges to the job that day.

Transactions will contain a rental transaction (start and end dates, equipment number, Job Number, ect.)

Billing is a weekly reckoning of the incurred cost of the transaction and therefore needs to be reported on the time card.  This is a portal on a popup to show equipment and amount billed that week.

I'm trying to make a relationship that relates billing to TimeCards by Date field in each (easy) and by

TimeCards::Idf_JobNumber to Billing::ID_Billing

via

TimeCards::Idf_JobNumber  =  Transactions::Idf_JobNumber

Transactions::Idf_Billing      =  Billing::ID_Billing

 

I know I could do it through portal filters but it will be used on GO over the WAN so I'm worried about speed.

I could create Billing::Idf_JobNumber and just populate it everytime I create (by script) a new record in Billing.  Is there a better way?

 

Thank you,

Tim

Outcomes