Help to display data on form from secondary tables

[richard-wanamaker]

I have a form where I am entering orders. For this, there is only 1 item and 1 customer per order. The Order_Table is the 'general' of the form.

However, I want a Customer_name dropdown on the form, and return data to 'display' on the form (but capturing and ONLY storing the Customer_no), once the user makes a selection.

Additionally, in the same vein, I want to have an Item_name list, where the user selects one from the listing, and display (again, no edit) the name. Again, only want to store the Customer & Item numbers on the Order table

Here's the 'general' table layout (I've taken out what doesn't matter):

Table: Order_Table
Order_no
Customer_no
Item_no

Table: Customer_Table
Customer_no
Customer_name

Table: Item_Table
Item_no
Item_name

 

[John Big Booty]

Welcome to the forum.

Perhaps the thread and sample here are doing the sort of thing you are looking for.