A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Auto Complete field



 
 
Thread Tools Display Modes
  #1  
Old February 24th, 2010, 02:35 AM posted to microsoft.public.access.tablesdbdesign
StevePlym
external usenet poster
 
Posts: 9
Default Auto Complete field

I am using Access 2010 and I have a datasheet which records Invoice data:

Invoice number
Client ID
Client surname
Invoice date
Invoice amount
Date paid

Invoice number is the primary key and the table is linked to the Client
datasheet.

I would like to be able to enter the Client ID in the Invoice Datasheet and
have Access auto complete the Client surname field. Is that possible? Would
I need to build an expression or is there something in Design that can be
used?

All help appreciated.


Steve


  #2  
Old February 24th, 2010, 04:19 AM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Auto Complete field

On Wed, 24 Feb 2010 01:35:53 -0000, "StevePlym" wrote:

I am using Access 2010 and I have a datasheet which records Invoice data:

Invoice number
Client ID
Client surname
Invoice date
Invoice amount
Date paid

Invoice number is the primary key and the table is linked to the Client
datasheet.

I would like to be able to enter the Client ID in the Invoice Datasheet and
have Access auto complete the Client surname field. Is that possible? Would
I need to build an expression or is there something in Design that can be
used?


The client surname should NOT EXIST in the Invoice table.

An invoice doesn't have a Surname as an attribute. Sure, a client does; but
you can *link to* the Client table, by the ClientID, to find it!

If you're interacting with data using a table datasheet... well, don't; that's
not what tables are for. They're to store data! You can instead use a Form;
this could (among other possibilities) have a Combo Box bound to (and storing)
the ClientID while displaying the client's surname, or (if you prefer) full
name. There is no need and no benefit to storing the surname redundantly.

--

John W. Vinson [MVP]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:13 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.