Link Records for Grouping in Same Report
I have a table that has 'Material Number' and 'Linked Material Number'. there could be 5 records with different Material Numbers, but all have the same 'Linked Material Number'. There can be 'Mate...
Forum Discussion
You would need a relationship to a new table called Linked Material Number. That would have a relationship down to the detail records and it would be able to summarize the information you need and look it up back down to the detail records.
The key field of that table would need to be set to be the field Linked Material number.
To initially populate that Table you would need to make a summary report on Linked material number to get all the unique values and then copy them, across to the new table.
If you go to add a record and the parent is not there, then you would need to create a new Linked material record for it. Alternatively if you want to continue to be able to just free form in the data for Linked Material, there is a way with using an Action to auto create the parent record.
So this is kind of tricky to set up if you are new to Quick Base. You may need some one on one help with this or several iteration on this forum here.
The key field of that table would need to be set to be the field Linked Material number.
To initially populate that Table you would need to make a summary report on Linked material number to get all the unique values and then copy them, across to the new table.
If you go to add a record and the parent is not there, then you would need to create a new Linked material record for it. Alternatively if you want to continue to be able to just free form in the data for Linked Material, there is a way with using an Action to auto create the parent record.
So this is kind of tricky to set up if you are new to Quick Base. You may need some one on one help with this or several iteration on this forum here.
Yes, so the Parent records in the Linked Materials table could be created automatically by an Action.