SELECT Customers.company, Transactn.track_num, Transactn.transdesc,;
Inventory.chgperkt, Inventory.clarity, Inventory.colors, Inventory.cut,;
Inventory.entered, Inventory.invoiced, Inventory.inactive,;
Inventory.karatwt, Inventory.measure, Inventory.p_descript,;
Inventory.stocknum, Inventory.total_chg;
FROM tomparco!inventory INNER JOIN tomparco!transactn;
INNER JOIN tomparco!customers ;
ON Customers.cust_id = Transactn.cust_id ;
ON Inventory.trans_id = Transactn.trans_id;
ORDER BY Inventory.stocknum

This view will pull the data for the customer table and the transactn table, but will only display the data for the stocknum field (primary)of the inventory table. Why?

Thanks
JD