Hi, I want to output a parent record and its linked child records (a variable number of records) as a JSON array to display in a html page that consists of sections. Each section contains one or more fields from either the child or parent record(s).
I would like to be able to push the data upon clicking a button.
Following is an example of what I mean. (NB: The actual Parent Table has 10 fields and the Child table has 60 fields, including some that are formula fields).
Parent table fields:
FIELD: PID PF1 PF2 PF3
TYPE (autonumber) text date number
Child Table fields:
FIELD: CID (autonumber) PID CF2 CF3 CF4 CF5
TYPE (autonumber) integer text date number checkbox
PID is an Integer field and relationship linked to same field in Parent table.