Multidimensional Forms/Tables

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.

Contact me at my email address below if you would like outside help with
this. My fees are very reasonable.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com


"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.

You just don't get it, do you Steve?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"PC Datasheet" wrote in message
link.net...
Contact me at my email address below if you would like outside help with
this. My fees are very reasonable.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

Why don't you explain it to me in concrete terms, Doug.


"Douglas J. Steele" wrote in message
...
You just don't get it, do you Steve?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"PC Datasheet" wrote in message
link.net...
Contact me at my email address below if you would like outside help with
this. My fees are very reasonable.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

These newsgroups are not intended for you to solicit commercial business.

You know that: you've been told MANY times by MANY different people, yet you
still persist.

Are you really that egocentric that you figure you can ignore everyone?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"PC Datasheet" wrote in message
ink.net...
Why don't you explain it to me in concrete terms, Doug.


"Douglas J. Steele" wrote in message
...
You just don't get it, do you Steve?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"PC Datasheet" wrote in message
link.net...
Contact me at my email address below if you would like outside help with
this. My fees are very reasonable.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

Doug,

I have always respected your approach and continue to feel that way. My
intent here is not meant to put you down in any way. I just am asking you on
a professional level where specifically does it say that offers of help on
an Access related problem for a fee are prohibited?

Steve


"Douglas J. Steele" wrote in message
...
These newsgroups are not intended for you to solicit commercial business.

You know that: you've been told MANY times by MANY different people, yet
you still persist.

Are you really that egocentric that you figure you can ignore everyone?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"PC Datasheet" wrote in message
ink.net...
Why don't you explain it to me in concrete terms, Doug.


"Douglas J. Steele" wrote in message
...
You just don't get it, do you Steve?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"PC Datasheet" wrote in message
link.net...
Contact me at my email address below if you would like outside help
with this. My fees are very reasonable.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

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.

Well I personally feel I have learnt a lot about multi dimensional tables!!

I shall be attempting to fit one into my database immediatley!