Dan Lynch
|
| Posted: 02/27/2003, 5:15 PM |
|
I am trying to design an application that incorporates a central table and many other linked tables (to the central table). I am trying to devise a way to provide a data input screen with the idea that the central table will have a one to many relationship with the lnked tables. I suppose a classic example would be an invoice in which data on the form is stored back into related tables.
Are there any examples of how this might be done. I have CCS 1.07
Thanks
Dan
|
|
|
 |
RonB
|
| Posted: 02/28/2003, 3:52 AM |
|
Basicaly you are asking how to setup a relational database. That's some question!
It would depend on the sort of data you are collecting and will grow complex if you need to store a lot of different info.
Invoice:
table client:
client_id
client_name (just one field or separate field for name. surname etc)
client_adres
client_city
etc etc
table products
prod_id
prod_category
prod_supplier
prod_name
prod_price
prod_inventory
table suppliers
supp_id
supp_name
supp_adress
etc etc
table product_cat
prod_cat_id
prod_cat_description
etc etc etc
The aim is to never store the same info twice to prevent data inconsistency.
Try to get some information on how a relational database should work (articles,books, etc)
Ron
|
|
|
|
Dan Lynch
|
| Posted: 02/28/2003, 6:45 AM |
|
I have the tables setup I'm just need to know whether I can present all these linked tables on the same page and do a data entry task. Presenting data from multiple linked tables is easy but I'm have a conceptual problem with how I can make an easy DE screen to allow users to easily enter data.
If I have then main table say server inventory which has only the "flat" info for the server like serial number, model, vendor. Then I have linked tables say sa table that would hold info on who might be primary and backup and lets say a software table to track installed software. This scenario would continue and have other related tables.
From my main add record which would be the main server table, how can I efficiently present and gather info for this linked tables. Once the data is in presenting it should be easy.
Hope this clarifies some. My original ? was pretty general.
Thanks
|
|
|
|
|
