Access 2010

[Shondalt]

Hello,

I want to be able to type a nickname for a contact and it populate the full name in a query for a report. Is there a way to effectively get this done? I have tried combo box and I am not sure how to use the drop down list function.



Please help.

[rzw0wr]

Just a little more information.
Where would you like to type the nickname?
Form? query? Table?

How are you planning to open the report? From where?

Anymore information that you would like us to know would also help.

Dale

[Shondalt]

Just a little more information.
Where would you like to type the nickname?
Form? query? Table?

How are you planning to open the report? From where?

Anymore information that you would like us to know would also help.

Dale

I did use a template that was already created. I modified some of the fields to fit what was needed. I don't want the nickname to show up, I just wanted to be able to type in the nickname in a search field for a report and for it to attach the person's name to the record.

On another note I have came across another problem. I want to import from an excel spreadsheet and for it to keep the records with sequential number order. It skips numbers when I import from different spreadsheets that have the same information.

[rzw0wr]

On the nickname question, make a field in your table called nickname and search by that field.

I am not sure what numbers you are referring to.
Are they the table ID numbers? The row numbers from Excel?


Dale

[orange]

If a Person can have more than 1(several) nickname ( if this is true for many people) then you may want to build a table specific to this.

tblPerson
PersonId PK
PersonFirstName
PersonLastName
..other person specific info


tblNickNames
NickNameID PK
NickName 'actual nick name
PersonId_FK 'link back to tblPerson

[Shondalt]

On the nickname question, make a field in your table called nickname and search by that field.

I am not sure what numbers you are referring to.
Are they the table ID numbers? The row numbers from Excel?


Dale

I am referring to the autonumber field. It automatically assigns a number to the record. However, when importing from excel or via email it will skip numbers.

[orange]

Autonumbers are intended for system use. They are unique; NOT sequential; NOT necessarily Positive.

[ssanfu]

See

Use Autonumbers properly
http://access.mvps.org/access/general/gen0025.htm

[rzw0wr]

Yes they will and what ssanfu said.

Dale

[orange]

Here's more info on autonumbers
http://www.utteraccess.com/wiki/index.php/Autonumbers