How To Get Name From Table And Insert It As ID To Another

**x_zero** · 03-08-2014, 03:53 PM

i have an access database that contain 2 tables and 1 form :
table1 named customers (custid-custname)
table2 named sales(salesid-custid)
form named form1 contain (salesid-custid)
*note:in form1 custid is combobox
what i need is when i select an customer from combobox the coulmn custid in sales table get custid not custname
i use this sql statement to get combobox items from customers table

Code:

SELECT Cust.[Cust-Name] FROM Cust;

sorry for my bad langue

**June7** · 03-08-2014, 03:57 PM

Form is bound to table2? Combobox is bound to CustID field from table2?

Review: http://www.datapigtechnologies.com/f...combobox3.html

How To Get Name From Table And Insert It As ID To Another

Thread Tools

How To Get Name From Table And Insert It As ID To Another

Similar Threads

Create query to insert and update records from link table into new table

how to insert records on some table using data on fields from other table

Insert/Update Table from form but restrict direct access to Table

Insert table(not database table) into a Form

Table form with records from a query to insert results in a different table

Posting Permissions