I am fairly new to XPages and very new to DECS.
I have set up an ODBC connection to our AS400 quality control database which pulls down data based on a key of the item code number.
A view control allows the item code to be input and then the remote database is queried and the resulting record pulled into Domino and displayed in a table.
This all works beautifully for a single item code entry.
My problem is that some items have more than one entry on the remote database. Eg: item A1234 could be logged on 3 or 4 different dates with a different quality issue on each date.
Is there a way to link to all records with a specific item code so that they can all be displayed on the table together?
I can't use another (unique) key because I need to query on item code within the xpages application I'm developing.
I hope I have explained this clearly but please let me know if I need to provide more details.