I need to display a list of ALL Customer Cross Referenced Part
Numbers from the CustXPrt table in Part Tracker. The main key to the
CustXPrt table is Company, CustNum, PartNum, XPartNum. Since I don't
want the list to be customer specific and need to show all cross
references found for a part number, it doesn't appear that a foreign
key view will work in Part Tracker since the documentation says the
search uses GetByID which I assume requires all key fields to be
populated. At least I haven't been able to get it to work no matter how
many ways we've attempted to set it up.
So the question is, how can I retrieve the CustXPrt data using
just Company and PartNum from within Part Tracker? Will it require
special code customization to retrieve the data into a list?
Thanks,
Ed
Numbers from the CustXPrt table in Part Tracker. The main key to the
CustXPrt table is Company, CustNum, PartNum, XPartNum. Since I don't
want the list to be customer specific and need to show all cross
references found for a part number, it doesn't appear that a foreign
key view will work in Part Tracker since the documentation says the
search uses GetByID which I assume requires all key fields to be
populated. At least I haven't been able to get it to work no matter how
many ways we've attempted to set it up.
So the question is, how can I retrieve the CustXPrt data using
just Company and PartNum from within Part Tracker? Will it require
special code customization to retrieve the data into a list?
Thanks,
Ed