Passing "text" to a table rather than "numbers". HELP!

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi there, can anyone help?

I have created a few tables with fields called...

Table: Country
Field: idCountry (Auto Number)
Field: Country (Text)

Table: Suppliers
Field: IdCountry (Numeric)

The idCountry field in the Suppliers table has a relationship with the
idCountry field in the Country table.

When you view the Suppliers table, you can see the country name,. Eg
Australia.
The SQL that Access created in the Row Source is...

SELECT [tblCountry].[idCountry], [tblCountry].[Country] FROM tblCountry;

When the website I created calls the information from the Suppliers,
idCountry field it calls the number of the country. Eg: 1.

Is there a property I can change in the cell or can I change the SQL so that
it actualy passes the text value rather than the numeric one?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200605/1
.

Relevant Pages