Two results from One Value List

[Eastern Snake-Neck]

This has probably been answered before, however...

I have a database that I am developing. In one table (called Books) I have a handful of fields which includes 'Book Title' (text) and 'Level' (numerical value).

In another table, I have a value list that uses values from Book Title (First Field) and Level (Second Field).

What I need to happen is:

When a user selects a Book Title from the value list, it then displays the Book Title, plus it also displays the Level in a separate field.

How do I make this happen?

Regards,

Michael.

[bcooney]

I hope that your Book value list consists of BookID and BookTitle, perhaps displaying only the second field. When you select a book title in Table2, you ought to be storing the BookID in a foreign key field (Table2:_kF_BookID). Then using a relationship btw Table1 and Table2 by BookID, you can either place the related Level field on the Table2 layout, or lookup its value into a Table2 Level field (Level_lu).

[Eastern Snake-Neck]

Thank you.