Cross Reference in the Sales Line

pburgov

Hi everyone, I have some Cross References for a particular Item&Customer. For Example:
[Customer] - [Item] - [Cross Reference No.] - [Description]
A - 1 - BOX - BOX 10 KG
A - 1 - TRAY - TRA 1 KG

What I want to achieve is that when I choose an Item in the SubForm Sales Line and then I type B in the [Cross Reference No.] this field fills with BOX and the [Description] field with "BOX 10 KG". But instead of this I get a message that reads: " There's no Cross Reference whith B".
Is there any way to do it similar to the AltSearchField Property?
Thanks in advance.

Faithie_Robertson

I'm assuming you're using the Item Cross Reference table to hold your cross-ref data, and not a custom table.

It sounds like you have more than one Cross Reference No. that starts with "B". Filter the table for cross ref type customer, your customer no., and the item no., and see if you find more than one that has a "B" as the first character of the Cross Reference No.
(Cross Reference No. is part of the primary key to the table).