DLookUp in Access Database

[Tech718]

i have 2 tables "member" and "memberpost" whenever a member makes a post to the member post table i want their name to show up automatically instead of their username which currently shows. is their a way i can make their name show up once the username is entered into the table. I have both the username and name stored in the members table. I know
dlookup is the answer but how do i apply this to a table?

 

[HarleyQuinn]

Yes, what have you got so far?

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[PHV]

Have a look here:

http://www.devshed.com/c/a/MySQL/Understanding-SQL-Joins

http://r937.com/relational.html

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[HarleyQuinn]

PHV - I can see what you're driving at but it's hard to gauge anything without seeing his/her code?

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.