Jump to content

Lookup Issue


miltont

This topic is 2749 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.....

Link to comment
Share on other sites

This topic is 2749 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.