scopping
11/16/2005 10:21:00 AM
I am having the same problem - just wondering if you came up with a solution?
"joewalter" wrote:
>
> I have a client who needs to send RMA (return merchandise authorization) documents out. They have a very fancy MS Word template for this and we are using document management to map fields in axapta tables to bookmarks in the MS Word template. Almost all data needed is stored in the table SalesTable.
>
> We have run into a problem because we must have the invoice account#, name and address and these are not stored in SalesTable - only delivery name and address are stored in it.
>
> We need to get the invoice name/address from CustTable, but document management uses the default join of SalesTable.CustAccount to CustTable.AccountNum and so it returns the delivery name and address.
>
> Is there anyway to override the default relations? If we could get SalesTable joined with SalesTable.InvoiceAccount == CustTable.AccountNum then we could get invoice name/address. Or does anyone know of any other way to get this data?
>
> It seems you can only get real fields from tables - not data returned from methods on the table and can only get fields from tables that have default relationships to the main table you choose and cannot override default relationships.
>
> technet.navision.com Posting date: Monday, September 29, 2003
>
> technet.navision.com Posting path: Navision Axapta/Technology (Ax)/MorphX