ok,

I have a database that house a table called model. The model contains a
manufacturer foreign key and 3 other fileds for that table. I want to be able
to take a <cfselect> and display all the rows, i.e, dell (manufacturer fk)
dimension 8400(model)p4(series)2.3ghz(speed) so it looks like

dell dimension 8400 p4 2,3ghz
dell optiplex 9600 p3 2.5ghz

there is the inventory table that has a faoreign key to the model table, but
if they are going to see all the possible chices, I can't pull from the
inventory table. Please help!

It depends on where the data is kept.

Basically it looks like a simple join.

select mfr.CompanyName, model.ProductName, model.ProductType
From mfr, model
WHERE mfr.idx = model.idx

You might need some grouping and sorting.