Print Layout multi table on one layout

[Brian12568]

Hello,

I think im having a brain freeze on this problem.

I am building a solution which will be used as CRM/Quotation/SalesOrder/Invoice etc... (well there the only bits involved for this problem) but obviously once one bit is working the others is just variations.

I have got the Layouts & Scripts/Tables sorted & working how i want..

however there is a need to print a Quotation (and sales order and ultimately invoice) out with the bill to address & the Site Address & then the details of the Quote & any parts to be used.

Just to give you the information you may need to understand the problem im having.

Tables

"CID" (cid is individuals they maybe involved with a Site or a bill address).

"client" This is the Billto address

"Site" This is the SiteAddress

"Quotes" This is the Table containing the quote Fields

Relationship with the above

Client

Field "ID" (main autonumbering field) connects to CID to a field called ClientID (1tomany)

Client "ID" also connects to Quotes to a field called ClientID (1tomany)

Client "ID" also connects to Site to a field called SiteID (1tomany)

I think that covers what is involved.

so on to my problem

I have a Layout that will show the billto address site address & in the case of the Quote the person who has asked for the Quote.

along with the quote details..

now the Client (billto) details is ok as the layout is pulling the records from Client table..

however the CID ie the person who asked for the quote isn't showing it is showing the first person associated with the billto address how can i get the layout to show the person i want?

likewise i would have the same problem for the quote details.

Thanks in advance for any advice

Regards,

Brian