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!
Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, and content available only to registered users.
Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, and content available only to registered users.
Display data
-
- 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.