Say I have a DMR with memos that are categorised as follows (there may or may not be memo text associated with these, but not important for this application)
Memo Category
Title
Disposition
Return To Supplier
SCNotes
Purchasing
Liability
Supplier
Is there a method for writing a BAQ that displays these as separate fields for multiple DMRs like this:
Little kinetic life hack to add to this; you can’t rename the table the first time you bring it into a baq, but you can if you bring the same table again. If I know I need 3 copies of the Memo table, I’d bring one in that I don’t intend to use, then bring in three more and name them with the categories you want to use them for. Then go back and delete the first one named Memo. This will make life easier as you work through the joins and adding display fields.
Thank you both for your responses, and especially TDray for the solution. I didn’t realise you could just add as many duplicate tables as needed, but come to think of it, I’m sure this is along the lines of something similar I did once in Access… it’s been a while…
Is it sad to say you have no idea how happy this made me?
