I have two lists with a parent/child relationship. I have a lookup field pointing to the parent with referential integrity which serves as my foreign key. I know that from views in the child list I can get columns from the parent list to show up such as text fields and number fields by checking off the additional columns from the lookup field in the child list pointing to the parent.
What I've come to find out is that certain field types do not apply, such as lookup or choice field types. Is there anyway around this? I've tried using a calculated field, however, this breaks my InfoPath form that we use to add, edit, or view list items in.
I need to be able to see these fields from the child lists views. If I use SP designer and use the datasource (join/merge) feature, will I be able to edit list items in the view or will it be read only?
I would appreciate any direction, thank you.