Hi, Just playing with Access fairly new to it (like days old). Also it's my first post here so if I'm in the wrong place, sorry..
What I'm wanting to know is basically I have lets call it Table Data and I've got Last Name, First Name in the columns. I than have Table Full Name, with column Full Name. I have a relationship between the primary key of Table Data and the column Full Name. I have a form that displays the Full Name column. Its in a drop down list but I can only get Last Name to appear. I want to be able to have Last Name & First Name to appear as two people may have the same last name. How do I do this? I'm a complete beginner at this and my database has been simplified to try to get what I'm trying to achieve across.
I've googled and found stuff about concatenating but yet to get it going. I figure there has got to be a relationship in order for me to the data combined in the drop down box but I could be waaaay wrong.
Thanks.
EDIT: By columns I think I mean fields?