Information générale
Catégorie:
Gestionnaire d'écran & Écrans
I want to fill a combobox with one of the fields from this view (I used the view designer):
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
Using the combobox builder, I check the Layout tab to make sure it is filled - and it is. But when I close the builder, the combo loses its connection with the field. IOW I can open the builder right back up, check the Layout tab again, and it is empty. Any Ideas?
Thanks
JD
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement