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


"TonyWilliams via AccessMonster.com" u56994@uwe wrote in message
news:a36edac5281bb@uwe...
I am building a database of financial deals for companies.

I will build a table with company details, including a field called
txtcompany and then another table with the details of the deals with a
field
called txtdealnbr and also a field called txtcompany to link to
tblcompany.
For each txtdealnbr there will be a field called txttotalline which
represents the value of the deal.

Now comes my question. Each deal needs to be analysed to show what
percentage
of the deal is either any one of 7 categories. So a deal could be 50%
cat1,
20% cat4, 10% cat5 and 20% cat6. However the user wants to be able to view
on
a form all 7 categories even in the %age is zero. So do I have 7 fields to
hold the percentage value for each category or do I build a table of
categories and if I do how do I show the value of each on my form? How
would
I construct the tables and theirrelationships.

Hope I've explained that clearly, any help would be apppreciated.
Thanks
Tony

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

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201002/1