Multidimensional Table/Form Question

Please see the attachment. How can I create a form like this to store
information.

Here is what I have done.

Created table BUSINESS , which has all the business names.
Created table CATEGORY , that has the Business name and Category Name.
Created table SUB CATEGORY , that has the Category Name and Sub Category
Name.

Created table APPLICATION , Which has all the Application Names
Created table COMPONET, Which has the Application Name and Component Name.

I have linked all the tables and have primary keys.

Create a query which would pull out all the Business, Category , Subcategory
, Application and Component infomation.

PROBLEM: If you look at the attachment I need to store values X. How doI
store this information and it which Table. Also how can I design a form like
the Excel sheet that helps me to store Information in a user friendly way.

Thanks,
Sharan.

Please review the newsgroup netiquette list -- attachments are not
appropriate. After all, would you open an attachment from someone you don't
know, posting in a public newsgroup?!

And some of the 'groups readers are still using slow phone lines --
downloading the post plus attachment can get expensive.

Having not seen the attachment, based solely on your posted message, I don't
understand your question. The "X" you mention ... is that a calculated
value? If so, don't bother storing it.

Is "X" an attribute? If so, is it an attribute of a BUSINESS, or a
COMPONENT, or ? That would be where it would be added.

A minor semantic difference -- forms in Access don't store data -- tables
do.

--
Regards

Jeff Boyce
Office/Access MVP

"sharan" wrote in message
...
Please see the attachment. How can I create a form like this to store
information.

Here is what I have done.

Created table BUSINESS , which has all the business names.
Created table CATEGORY , that has the Business name and Category Name.
Created table SUB CATEGORY , that has the Category Name and Sub Category
Name.

Created table APPLICATION , Which has all the Application Names
Created table COMPONET, Which has the Application Name and Component Name.

I have linked all the tables and have primary keys.

Create a query which would pull out all the Business, Category ,
Subcategory
, Application and Component infomation.

PROBLEM: If you look at the attachment I need to store values X. How doI
store this information and it which Table. Also how can I design a form
like
the Excel sheet that helps me to store Information in a user friendly way.

Thanks,
Sharan.