Page 1 of 1

Display data

Posted: Sun Aug 22, 2021 11:34 pm
by GlenMcCabe
I have a DB structure which has a client table. Each client can have many referrals.

A client may be a carer for a different client

I have been asked to cater for a referral which can DISPLAY and not amend client details of the carer.

I select client A which then displays details of client A and an Iframe which has current referrals for client A in a browse / edit form.

I select the required referral (or add a new one) and in the carer tab of the referral edit I want to include several columns of Client B record.

Can I do this.

Re: Display data

Posted: Mon Aug 23, 2021 8:23 am
by GlenMcCabe
As a test I added a lookup object which browses thw client file and on selection ouputs the fullname of the client. This is a concatination of title, forename, middlename, surname. This works fine.

I then added an input object, text, readonly and typed in an id of gen.

In afterbrowse of lookup value I put

$lu = nuLookupRecord();

nuSetFormValue('gen', $lu->gender); ---------- gender is a varchar(30)

When I now lookup and choose a client the busy circle appears and does not return to the edit form. If I close the browse form the lookuo element is populated correctly but gender is blank.