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.
Welcome to the nuBuilder Forums!
Register and log in to access exclusive forums and content available only to registered users.
Register and log in to access exclusive forums and content available only to registered users.
Display data
-
GlenMcCabe
- Posts: 114
- Joined: Sun Sep 29, 2019 12:40 pm
Re: Display data
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.
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.