Hello. I have this 3 sheets named Expense, Payments and Payment to Expense.
Since one expense may be paid multiple times like 100 can be paid by 1 x 50 , 1 x 30 and 1 x 20; and a payment may be applied to multipleexpenses like a payment of 100 may be paid to 1 x banana @ 50 and 1 x apple @50, I created this relationship to link 1 expense id to multiple payment id and vice versa and I achieved it but one concern I have is I am trying to add the refrow column to my expense form so that when an expense is recorded i can navigate directly to adding a payment entry via add button on refrow column and i can only achieve that if the expense id column in the paymenttoexpese sheet is marked as “is part of” but when i tick that and save the form it always return to be unticked.
I tried to uncheck the is part of box of the payment id and the ispart of box of the expense id is now fixed. So is it posible that the issue is Apsheet wont allow me to have 2 of expense and payment id posses that is part of simultaneously? or am i missing something here
NOTE: I checked and made sure that the set up of 2 ref columns expense id and payment id is identical and they are except that “is part of” part that i really copuld not get them work both at same time.