|
I have an update form which pulls information from a database. The information is pulled from cells which are set to numeric because of the relationships created.
When the information is called to the update form you see the following result.
Country: 1. Where as we would like to see the following.
Country: Australia.
My question is how do I get the database to show the text version of Country? but still submit as numeric.
A small example of my database...
Table: Country
Primary Key: idCountry
Text Field: Country
Table: Suppliers
Primary Key: idSupplier
Numeric Field: idCountry (which has the relationship directly to the idCountry field in the Country Table).
Mally.
|
