Forum Discussion
MichaelFrishman
8 years agoQrew Cadet
Thanks for the reply. I need to do further calculations with the cost data that need to summarize, so a summary report isn't going to work.
I'm not following your last comment. I have created a parent table with every possible combination of YYYY-MM-DIV, which is the unique key field in the parent table, but in order to make the relationship to the same data in the details table, I'd have to use a function to concatenate the three fields to one, which doesn't work.
I'm not following your last comment. I have created a parent table with every possible combination of YYYY-MM-DIV, which is the unique key field in the parent table, but in order to make the relationship to the same data in the details table, I'd have to use a function to concatenate the three fields to one, which doesn't work.