Lookup Issue

Hi Everyone,

This problem has probably been asked a million times but I cannot work out how to achieve the following:

I have a table called UserDocuments2 and in this table I have 2 fields (among others) called UserDocuments2::DocumentName and UserDocuments2::DocumentText

This works fine and I can create new documents and store in a portal.

What I want to have happen is over on my Notices Table, when a user selects the field Notices::Header a DDL using the data from UserDocuments2::DocumentName is entered into Notices::Header (this works)

but also the associated data from UserDocuments2::DocumentText is auto entered into the field Notices::Text

I have tried various configurations off lookups but nothing seems to work.

I am assuming that my relationship between the 2 tables is incorrect, currently it is Notices::_id_Notices_PK = UserDocuments2::_id_Property

Any help with step by step instructions would be appreciated.

Thanks everyone for such a great forum.

Milton.....