Most of my 'job' records have multiple 'contacts' so I have table 'job' which connects to table 'contact' via table 'jobcontact' using a many to many style relationship.
If I set my 'jobcontact' table to only display the 'contact_id' field in the 'jobcontact' list page then I can add new 'jobcontacts' to a job from within the 'jobcontact' inline children area from on the main 'job' list page by doing a name lookup to the 'contact' table.
When I add additional fields to the 'jobcontacts' list page (like contact_phone, contact_email, contact company) that I want to see in the inline children area my application will display the correct information, but fails to update new records by displaying "Record was not added unknown column 'somefieldname' in 'field list' after click update.
I've set all the fields except the 'contact_id' to read only
How do I display the additional information and still maintain the ability to update the 'jobcontact' records.