I have three forms: One form is where I submit a new sale (Nueva venta), this form has a subform with the detail of the products sold (Detalle). Those two are linked so my reports can include data from both forms.

I also have a separate form with invoice data (Facturacion) and this has a bidirectional relation with 'Nueva venta' so that each sale has a related invoice.

For reasons particular to my business I need to have a view displaying everything in form 'Detalle' (all items sold) and in this view I want to display for each item what invoice it is related to. This last part is what I'm having trouble with since 'Detalle' and 'Facturacion' don't have a direct relationship I can't add a column for the invoice number in my report for 'Detalle'.

I'll try to sum it up like this:

Form A (Nueva venta) <-> SubForm B (Detalle)

Form A (Nueva venta) <-> Form C (Facturacion)

How to display a field from Form C (Facturacion) in a report based on SubForm B (Detalle)?

I can't figure a way to create a bi-directional relationship between SubFormB (Detalle) and Form C (Facturacion). The workaround that I thought of is adding a field in Form A (Nueva venta) that duplicates the field Invoice number from Form C (Facturacion). That way, since Form A (Nueva venta) has a bi-directional relationship with SubForm B (Detalle), I can just pull the data from there.

However I came to ask here first to the smarter minds of Zoho Creator if there's a way to pull the data without duplicating the field and having to make sure that any edit/update is recorded on both fields.

I hope I was able to explain the situation well and thanks for any help!