I have a main form and a subform that have the same field- e.g. TReference.
In order for the subform to show only the related records that have the same TReference , I have added the entry TRefrence to the show single category value. The entries appear fine.
The problem arises in the view for the subform. The entries that appear correspond to the main form. When a user clicks on TReference in the sub form view, the main form is loaded. What do I need to do to avoid this?
I think that you may be using incorrect Lotus Notes terminology here.
Subform in LN means a form that is included within another form.
By the context of your email, I think you mean a subsidiary form used for associated records of the main form. Please correct me if I’m wrong.
If the view is showing the correct subsidiary documents but these are opening using the main form, check if you have any form formula in the view or any queryopen code.
What I meant was a form with an embedded view. I am using the show single category to filter the related data by using the same field. e.g. An Order form, and Item form. The order form contains an embedded view of the Items. I display related records using the OrderID which is a common filed between both forms.
In the view outline, when I open the Item View that has fields OrderID, Item, Quantity and Price, I get the Order form. I guess because of the shared field. What I want is to click an entry in the view and get the item form.
I tried placing a SELECT Form = “Item form” in the View Selection formula but it is not working properly.
Hope this is a clearer explaination of the problem.