entering data in one field automatically adds data to another field...

  • Thread starter Thread starter Ev_
  • Start date Start date
E

Ev_

hi!

i'm making a database for a local company and to make things easier I
thought it would be cool to have fields fill in automatically (in my
example upon entering the members ID the members name and address
fields would automatically fill in). I have absolutely no idea where to
start with this. I browsed through my access book I bought but cannot
find anything relevant.

although I am making this for a local business it is non-profit as I
know the chap and i'm doing it as a favour.

i'm thankful for any help regarding this matter

thanks again,

Ev
 
hi!

i'm making a database for a local company and to make things easier I
thought it would be cool to have fields fill in automatically (in my
example upon entering the members ID the members name and address
fields would automatically fill in). I have absolutely no idea where to
start with this. I browsed through my access book I bought but cannot
find anything relevant.
Click to expand...

Well...

DON'T.

A relational database uses the "Grandmother's Pantry Principle": "A
place - ONE place! - for everything, everything in its place".

You should store the Member's LastName, FirstName (separately!),
address, etc. in the Member table - and not in *any other table*. If
you need to see the member name in conjunction with data in some other
table, just store the MemberID in that table and use a query to link
the two tables.
 
thanks I wouldn't have thought of using forms, but i'm still stuck wit
the issue of auto-inputting. I have attached a file t
better-demonstrate what I mean.

Using the drop-down menu, i'd like to be able to select a memberI
which upon selecting puts the correct name in the adjacent field (th
name field)

+----------------------------------------------------------------
| Attachment filename: sample.jpg
|Download attachment: http://www.MSAccessForum.com.com/forums/attachment.php?postid=221177
+----------------------------------------------------------------
 
the process works in the form with CD-ID in that it fills in the
CDArtist and CDTitle fields, but when I alter the MemberID it gives me
an error.

Also, how would I have the QRY open up with blank fields?

Another issue i've been trying to work out would be to; upon selecting
all parameters including RentalPrice (a link table with 3 possible
variances) and then inputting the date in which it was rented
out....the DATEDUE field will auto-fill in with the correct day. is
this actually possible?


+----------------------------------------------------------------+
| Attachment filename: sample2.jpg |
|Download attachment: http://www.MSAccessForum.com.com/forums/attachment.php?postid=221178|
+----------------------------------------------------------------+
 
Back
Top