I have entered one entry in to the database with the correct values (this is record 6) and everytime I enter a new record, the data is the same (I'm using a drop down list) it will automatically appear in the box. But when I goto the table that the data is stored in, each field just has the reference to the first record that the data came from.

Looks a bit like this:

ID Server Name Pattern Engine Program
6 LN1HOME 4.735.00 8.500-1002 5.58.0.1185
7 LN1WORK2 6 6 6

Is there a way of seeing the origonal data in those fields other than the Record ID Number as a reference. :confused:

I know its a lame question, Im just is a learning process at the moment.

thanks in advance.

It's not obvious how you get the record ID from your first record into your lookups unless you are basing the lookups on the same table. However, table level lookups are a very bad idea. They only work in the most basic of situations and create all sorts of problems as your application progresses.

Can you describe what you are trying to do in a bit more detail?

What I have done now is seporated the different data in to mini tables, and link them with relationships.

(I wish I had paid more attention to the teacher at school and college!!)