I have a query which is pulling the following data points into a grid/listpage. (Table.Field)
- CustInvoiceSalesLink.OrderAccount
- CustInvoiceSalesLink.InvoiceAccount
- CustInvoiceSalesLink.SalesId
- CustInvoiceSalesLink.InvoiceId
- CustInvoiceSalesLink.InvoiceDate
- CustInvoiceSalesLink.InvoicingName
- SalesLine.ItemId
- InventDim.SerialId
- CustInvoiceSalesLink.CustomerRef
- CustInvoiceSalesLink.PurchaseOrder
We have a warranty claim system built by our VAR and I'm working on enhancing some of the features.
The fields above will allow our warranty techs to get information faster. From here I attempted to create a fact box which will display the following from our claim database. (Unfortunately it was developed as one table and not really normalized.)
- CustClaim.ClaimNumber
- CustClaim.ClaimDate
- CustClaim.ProductNumber
- CustClaim.Serial
- CustClaim.ReplaceSerial
Is it possible to have a fact box linked to multiple fields? I'd like to be able to have the factbox go out using the CustInvoiceSalesLinke.OrderAccount == CustClaim.CustomerAccount (not displayed) and SalesLine.ItemId == CustClaim.ProductNumber
I noticed that you need to have dynalink relations but will that work even if you're using a query for both the main data source and the datasource for the fact box? That would mean I'd have to put a relation on SalesLine.ItemId <-> CustClaim.ItemId and CustInvoiceSalesLink.OrderAccount <-> CustClaim.OrderAccount
Thank you for your time.
Cheers,
Bob
*This post is locked for comments
I have the same question (0)
