This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.
If I link records in TableA to records in TableB via a "Link to another record" field, I get a column in each table reflecting the link. So I can look at the row in Table B and see which records from Table A link to it. However, as of now, when linking to another record in the same table I can only see on Record A that it links to Record B and Record C I link to -- there is no corresponding field on Record B or Record C that shows the records that link to it. Thus, I cannot run a rollup or look on the fields linking to me.
This is valuable for modelling two-way markets. For example, I buy a lot of commodity in Record A. I sell some of the lot in Record B and the rest in Record C, it would be extremely time-saving to be able to link Records B + C each to A, as "from lot A", then to have a field on A which shows the sold quantity (Rollup of quantity from linked Records B + C).
To accomplish the same today, you have to enter Record B + C, then open Record A for editing and put the link there -- greatly slowing data entry.
Anyone linking records within the same table who wants to be able to calculate aggregates. this seems to be a common enough question on the forums to have elicited some long frustrated chains.