colinmatthews

Related fields

Discussion created by colinmatthews on Jan 31, 2014
Latest reply on Feb 1, 2014 by erolst

Hi all,

 

Is there a way of making a field ID match that of the record in another table so that they match and can be shown in a portal?

 

I have a Customer layout and a Tasks layout. I have a portal on the Customer layout from the Task layout. The problem is that if I add 5 Tasks to Customer #1 in the portal window then these tasks are added to customers 1-5 rather than all in Customer #1.

 

I realise that this is because both the Customer PK field and the Task FK field are set to auto-increment by 1 and have therefore tried the alternative options but none of these seem to work.

 

Any pointers would be greatly appreciated.

 

Thanks,

 

Colin

Outcomes