File Lookup

[bramkip]

Hi,

In a Form I want to display a username which I'm reading from a different file. In the 'LoadRelatedRecord' I'm getting the record but I want to display the username from that record also. Just like a lookup (number and name), but without a lookup button.

How can I manage that?

Thanks

Bram

[Bruce]

Inside the LoadRelatedRecords routine load the record you want.
Then push the fields into the session queue. You can do just the fields you want, or the whole record.

For example;

usr:id = 5
Get(User,usr:key)
p_web.FileToSessionQueue(User)

Then on the form just use the usr:name field as a normal form field. I guess you'd probably make this a Display field, because obviously editing it won't do anything in this situation.

Cheers
Bruce

[bramkip]

Hi Bruce,

That is what I'm looking for. It works great.

Thanks

Bram