Thanks John and Steve for those suggestions. I think I understand the concept,
I've just done something similar for another of my posts. However, Steve, how
would I create a query that shows all 7 categories on a form when I'm only
holding one value?

Thanks
Tony
Steve wrote:
Hi Tony,

A little revamp of your tables is needed:
TblCategory
CategoryID
Category

TblCompany
CompanyID
CompnayName
other company fields

TblDeal
DealID
CompanyID
CategoryID
DealCategoryValue

With these tables you can create a form/subform where the main form is based
on TblCompany and the subform is based on a query that includes TblCategory
and TblDeal. You need to design the query to display all the categories and
the DealCategoryValue for each category.

Steve


I am building a database of financial deals for companies.

[quoted text clipped - 21 lines]
Thanks
Tony

--
Why don't my grey cells communicate with each as fast as they used to? I hate
getting old!

Message posted via http://www.accessmonster.com