Forum Discussion

LeslieG's avatar
LeslieG
Qrew Cadet
8 years ago

How to relate many records to many other records in the same table?

I have a table called "Accounts" where we store all of our customer data for order tracking and invoicing. Some accounts are individual artists and some are art galleries. Here's my issue: We need to ...
Relationships
TanishaElias's avatar
TanishaElias
Qrew Trainee
7 years ago
Hi Mark -- I am having an issue with something similar...

I need to create a summary report. All my data is on one table. But I have about 12 different fields with 5 different status categories, and I have to create one report showing a summary for each field reflecting the status. Because there are 12 different fields with 5 different status, I am having trouble bringing them all together in a report. Please help:)