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...
the table 'COGS' is the parent table and has relationships to child tables. but for this report i do not anything from any of the childern, all needed fields are in COGS.