Child report table on Parent record
So I need an answer to 2 questions here: 1) How do I get the child report table that appears on the parent record to extend all the way accross the screen. I have attached a pic. 2) Is th...
Forum Discussion
For the # 2 question, I assume that you have a relationship where 1 Parent has many Children. Open up that relationship and on the left side you will see a button to make a summary field.
- This works, but the field list is limited to what I assume are "numeric type fields". Is there any way to combine formula text fields from a child to a single field in the parent. example; I have a field on each job card for items used, I want to get all the items used accross all job cards and summarise in 1 field on the parent record
- Can you give some examples of the current set up you have and the information in the field you are looking to summarize? Maybe an example of what you want it to look like?
- setup is as follows:
Parent table: Job
Child table: Job Cards (multiple job cards per job)
In the child table, there is a text field where the user lists the items seperated by a comma. I have a formula text field that takes the items and lists them below each other after each comma.
What I want to do:
1) Combine all the items together (accross many child records) - and show it on the parent record.
2) Create a summary report for these fields as well. - It is possible to do a series of what are called reverse relationships to float up text values form a limited number of child records. In practical terms how many child records would you need to be able to handle?
- How do you create a reverse relationship? I'm having the same issue but my example is more like: "Parent table: Practice, Child table: Multiple Providers
