View containing fields from different forms (cross-tab) possible?
Posted on 2010-01-03
I am currently working on a redesign of a LN database and stuck with one issue, hope you can help me:
I have 3 forms each linked with the others via a keyfield.
some fields like Letternumber, date, etc... and
embedded view showing all related forms B (via field Parent ID = @DocumentUniqueID of Form A)
again some fields eg start date, end date and
embedded view showing all related forms C (via field ComponentID =@DocumentUniqueID of Form B)
basically 2 fields: Component Name and Component Qty
Now I am trying to create a view provided me with an overview of fields cross the forms:
Header: Letter number | Date | StartDate | EndDate | "CompName - FormC" | "CompName1"
Values: FormA -Letter | FormADate | FormBstart | FormBEnd | FormCcompqty | FormC1compqty
FormA -Letter | FormADate | FormB1start | FormB1End | FormCcompqty | FormC1compqty
I was thinking about computed cloumns to create this view however I am not sure if this is the right approach, please help.