I have a child list, "Actual Expenses", that includes a lookup column to link it to an item in a parent list, "Budgeted Expenses". I don't necessarily want every item in my child list, Actual Expenses, to be linked to an item in the parent list, Budgeted Expenses; it is not a required field. In my parent list, Budgeted Expenses, I want to be able to open an item and quickly view all of the linked Actual Expenses items, so I've added the list control to my parent list form to show those linked items.
However, if I try to add a new item in this parent list form for Budgeted Expenses, in the list control for Actual Expenses, it will display all the items where the value in that lookup column is currently blank. And then if I save that new item in the parent list, it automatically updates the lookup column for the Actual Expenses items to link to this new item. I'm not sure whether this is expected behavior or if this is a bug-- and if it's expected behavior, how do I prevent this from happening? When I create a new item in the parent, Budgeted Expenses list, I don't want it to affect/link the items in my child list where the lookup column is blank.
Any help is appreciated!