If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Multidimensional Table/Form Question | sharan | Database Design | 1 | October 8th, 2005 12:55 PM |
Duplicating Forms/Tables | Charlie | New Users | 2 | May 17th, 2005 08:20 PM |
Making products - laying out forms/tables | babs | Using Forms | 6 | December 7th, 2004 09:59 PM |