Hi,
I have tried to associate the current user with an insert basic form without success. I have a custom table with a lookup field to the 'User' table.
I have tried 'Associate Current Portal User on Insert' and 'Associated Table Reference' and 'Metadata Prepopulate' and 'Metadata Save Value On Save' individually and a combination of these without success.
I get the impression from the options I get and from reading posts from people with similar issues, that these options are targeted at the 'Contacts' table and not the 'User' table.
The closest I achieved was using 'Associated Table Reference' and hiding the Lookup field in the form. This saved the record without the user name, even though its a required field?
On submit of the form I either get 'The form could not be submitted for the following reasons: Staff List is a required field'(if the field is visible) or 'The requested record was not found' (if the field id hidden)
Please Help
