Search found 4 matches

by justbob3377
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...
by justbob3377
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...
by justbob3377
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...
by justbob3377
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...