updating a field in a table

[aymanmb]

Dear all,

I have a simple database with few tables for which I created forms for the user to enter data.

I craeted in one ofthe forms a ombobox that reads from a table (list of suppliers fro example). I want the user to be able to select a supplier name and then this selected name will be fed to another table (order form for example). I did all requested work as I could understand bi\ut the end results is that it writes only the corresoponding ID number (e.g. 3) of the supplier and the supplier name itself (text).

Am I doing something wrong or missing a code?

appreciate helping a newbie

regards

 

[neileg]

That's the way relational databases work. Storing the ID is the correct way of doing it. If you want to show the name, use a query to join to the supplier table.

 

[Moniker]

What he's saying is, your structure is right.

[B]SupplierTable[/B]

[U]SupplierID[/U]   [U]SupplierName[/U]
1            Supplier1
2            Supplier2
3            Supplier3
.            .
X            SupplierX

[B]OrderTable[/B]

[U]OrderID[/U]      [U]SupplierID[/U]   [U]OrderDetails[/U]
1            1            Some_detail_field_here
2            1            " "
3            2            " "
.            .            .
X            X            X

The above is right (albeit simplied). To get the Supplier's Name to say put it on an invoice, a very easy wasy is with a DLookUp, like so:

Supplier_Name_Field = DLookUp("[SupplierName]","SupplierTable",[SupplierID]=" & SupplierIDField)

 

[aymanmb]

thanks but where should I put that code