First, try again with the JOINS Un-nested:

>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;
         ON  Inventory.trans_id = Transactn.trans_id;
     INNER JOIN tomparco!customers ;
        ON  Customers.cust_id = Transactn.cust_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?

It actualy makes better flow [to me] to do the following:

FROM tomparco!customers ;
INNER JOIN tomparco!transactn ON Customers.cust_id = Transactn.cust_id ;
INNER JOIN tomparco!inventory ON Inventory.trans_id = Transactn.trans_id ;