Well Sharon,
You must be wondering what the hell you have started here.
I wish I could address you problem, but I cannot.
I hope somebody answers you question soon.
BTW its not a good idea to send attachments with your posts. Generally
no one will open them fearing a payload!

Cheers,
WSF

sharan wrote:
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.