General information
Category:
Forms & Form designer
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only