Combo Boxes from Foreign Tables

[wazawak]

I am trying to add product information to an existing "OrderDetails" subform, so the user can input what products are in a particular order. However, product information is in a separate "Products" table, and there is no place in "OrderDetails" to store the data.

ProductID is related to OrderDetails, so I think there should be a way to pull product data right into the form. Unfortunately this is proving more difficult than anticipated.

I have tried to do it with the cbo wizard, but there is no place to "store" the data in that table, and just "remembering" it does me no good either. If anybody could offer any tips on how to create a combo box from a table that is not included in the form, I would be very grateful.

 

[missinglinq]

Obviously, you need to have fields in the underlying table for your OrderDetail subform to store this data! How else do you expect Access to know what an order consists of?

 

[wazawak]

Yes, but the fields I want this form to report already exist in my Products table. Every row in OrderDetails pertains to one line in the order, to one product.

I am trying to put all this information in one place so that it will be easy for the user to select which product this particular row pertains to, and to see relevant information about the product. Since the ProductID is related, I can put that in, but that's just a meaningless autonumber. Isn't there a way to "mask" the ProductID and get Access to display ProductName and RetailPrice?