Question Help needed using lookup

[zckzck]

Hi,
I've got a table with a few columns, and I want to be able to fill data to one of the columns (lets call this column "info") only according to the data found in another column (lets call this column "title") in that same row.

I have another table that correlates between the "info" and "title" columns.
Example:
info title
blabla Woof
albalb Rabbit
gittygoo Spoof

In order to do that I chose to use the lookup feature.
What I can do now, is have the optional data for the "info" column as aaaalll the data in the table (in the example it will be "blabla","albalb","gittygoo")

What I want is to have only the right one. That is, if in the first table I filled the "title" cell with "Woof" I want the "info" cell to automagically fill itself with "blabla" because that's how it is in the other table.

I hope I was clear enough, if not please tell me..
Is lookup right here? If so, how can I query using the data that was used in a certain cell in that same row?
If not, is there another way of doing it?

Thanks!

 

[stopher]

Hi and welcome to the forum.

I assume you are talking about Access here?

The principle behind Access (and most relational databases) is that you do not replicate information or copy it from one table to another like you are suggesting here. Instead, when you need that information to be made available, you do so by creating Join query which includes the fields from one or many tables linked by the appropriate keys in each table. Then you use the query as your data source e.g. to create a report.

I suggest you read up on normalisation/normalization and relational databases. I would also suggest you search for some basic Access tutorials as they will give you an idea on how queries work with tables etc.

hth
Chris