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.