text box on a form

[azhar2006]

Hello Guys
I have a text box on a form based on a field in a table city


When you open a form field appears the city and the number is not text
Can I do to delete the primary key for the table of the city
Or what to do
Thank you

[June7]

Options:

1. multi-column combobox - this is lookup with alias
http://www.datapigtechnologies.com/f...combobox3.html

2. Include City table in form RecordSource with join type "Include all records from tbStudents and only those from City that match". Bind textbox to Stiy field set it Locked Yes and TabStop No

3. Eliminate the ID primary key from City table, make City field in tbStudent a text type and save the actual city name

4. DLookup

[azhar2006]

Thank you very much
Oh wonderful teachers
Include City table in form RecordSource with join type "Include all records from tbStudents and only those from City that match". Bind textbox to Stiy field set it Locked Yes and TabStop No