I have seen solutions such as:
Go to record
Create New record
It doesnt work.
Instead of 'Go to record', go to a layout of Report.
My mistake sorry, I think thats what I have been using.
Is there something I might be missing in field set up like making id global or allowing creation of records via relationship as i have tried and tried but failed to make this script work??
Is there something I might be missing
It's hard to tell with so little detail.
In any case, an ID field should NOT be global, and the method should work without allowing record creation via the relationship.
I tried to be as detailed as possible :)
Could you be as kind to detail the script fully i.e what what goes where in set variable and set field script?
I tried to be as detailed as possible
No, you haven't provided any details about your actual script - other than "It doesnt work".
Anyway, see if this helps: