Need help showing substitute stock numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table that has one field of primary stock numbers and another with a
substitute stock numbers for the primary stock numbers. The way table reads
is there will duplicate, triplicate, or more primary stock numbers with
different corresponding substiute stock numbers. eg..,
STK# Sub STK#
100 55555
100 45555
100 35555
101 44444
101 34444
What I need to do is produce a query or table that will have the following
format;

STK# Sub STK# Sub STK# Sub STK#
100 55555 45555 35555

Basically, I have to show the primary stock#'s with all of their
corresponding replacement #s beside them. Tried to figureout a quick wayout
of this but using MIN and MAX doesn't help since I have some files that more
than 5 sub stk#s.
Thanks for any help in advance that you can provide me
 
The purpose is that they can be uploaded to another database by a 3rd party
and they would have to be in that format. Also I should mention there is a
3rd field that displays the a Priority Code which states which sub stk# is
the most preferred.
Thanks again.
 
Back
Top