Search found 4 matches
- Mon Jul 21, 2008 7:30 am
- Forum: Databases
- Topic: When OrderDetails is Zero
- Replies: 2
- Views: 321
Re: When OrderDetails is Zero
While such a design wouldn't break any Data Modeling Rules - as far as I know - it could cause conflicts when you query data!! On the contrary, it does violate schema design rules. You're dividing an entity (the incurring of an expense) across two tables. You lost me here, friend?! This is a parall...
- Sun Jul 20, 2008 5:48 pm
- Forum: Databases
- Topic: When OrderDetails is Zero
- Replies: 2
- Views: 321
When OrderDetails is Zero
Here is something I've been pining over... Let's say you have a database with an Expense and ExpenseDetail table, respectively. And, let's say that there are two types of data entry forms: Form #1: Expense-level only Form #2: Expense-level + ExpenseDetail-level For most things (e.g. Groceries, Retai...
- Sat Jul 19, 2008 3:03 pm
- Forum: Javascript
- Topic: Creating Dynamic Web Sub-Forms
- Replies: 2
- Views: 362
Re: Creating Dynamic Web Sub-Forms
Would you post your table structures? I have some concern about your data normalization. Well, relevant to this conversation... (1) Expense ---> (m) ExpenseDetail (1) Expense (super-type) ---> (m) Expense (sub-types) *As described earlier Trust me, there are no normalization issues here! :wink: Jus...
- Sat Jul 19, 2008 7:44 am
- Forum: Javascript
- Topic: Creating Dynamic Web Sub-Forms
- Replies: 2
- Views: 362
Creating Dynamic Web Sub-Forms
Not sure where to post this?! In my database model, I have a SuperType (tblExpense) and several related SubTypes (tblFuel, tblElectric, tblTelephone). On the data entry form I want to build, users will always see "ExpenseID", "ExpenseDate" and "MerchantName" which are i...