cowens1

Linking more than one field in Table Occurrences

Discussion created by cowens1 on Jan 10, 2013
Latest reply on Jan 10, 2013 by nickchapin

Scenerio:

You have a T.O. for, say INVOICE

and that T.O. is linked to workorders, ie ; invoice_WORKORDER

and the linking fields are _kf_JobNo in Invoices, and _KP_JobNo in Workorders.

 

Question:

If a 2nd set of linking fields is added, does that addition RESTRICT the link to records matching BOTH fields,

 

OR

 

Can the 2nd link be used to match records independet of the 1st set of matching fields?

 

Just Curious. (I guess I could try it to find out!! Oh Well, this is written now. Looking forward to a response )

Outcomes