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.