Storing numbers and not text

[znpnh]

Hi,

I have a table with an auto number primary key field, and then several other fields, Address, Unit, Owner. I created a form with a combo box that looks up the Address from another table and populates the three fields when you click a record. I have it set to store the first value, (Address) in the table. When I open the table, it appears as the primary key number, and not the address. It's very frustrating, as this happens a lot to me. What am I doing wrong? and how can I store the value I want, (Address) and not the primary key number? Help!!

 

[bob fitz]

Actually, you should not be saving the details of the address in more than one place. Storing the Primary Key from the Address table is exactly how a relational database is designed to work.
Perhaps you would benefit from reading a little more on db design and relationships.