Okay, writing the reply is gonna take some time. Bare with me.
In the meanwhile: Is there a article on Bytes on how to determine (and set-up) the best kind of relationship between tables? I've been playing around, trying to change the type of one from 1-M into 1-1 or into M-M, but couldn't find any option (Access 2003).
Regards,
Chris
ChrisWisselo
Last Activity: Feb 1 '12, 02:51 PM
Joined: Jan 29 '12
Location: San Antonio de Belen, San Jose, Costa Rica
-
@NeoPa
1. Would a 1-M relationship be suitable for those tables?
2. If I change Customers - ContactLog into a 1-M, would that work?
3. Changed into 1-M
4. PayMethod provides the different Methods available for paying: [Cash, CreditCard, Check, Transfer/ Deposit, PayPal]. The details of those methods are stored in PayMethodDetail .
5. The site itself doesn't have to many details.
However, it is not unheard...Leave a comment:
-
@NeoPa: Posted my design (as a .png-image) in a new question: http://bytes.com/topic/access/answer...-design-reviewLeave a comment:
-
DB design review
Hello everyone.
I have designed a database, but would like to get some feedback before actually building it. At this time I'm particular curious about the fact if it matches normalisation and if so, which class (1NF, 2NF or 3NF). Let's find out if I understand the normalisation-principle. LOL
The whole design is rather big (15 tables), but I would like to gather/ store as much info as possible on customers, products and... -
Thanks NeoPa! :D
I will also post my 'design' on the forum later, to get a bit more feedback on the structure. It's just in Microsoft Visio though, but it helps me to get a clear overview.Leave a comment:
-
Hello NeoPa.
Thanks for the article! That's making quite some sense to me.
I'm re-doing the whole database structure to make sure it is normalized to N3.
To bad I'm so ambitious and my database is gonna be holding quite some tables. So re-thinking the whole thing, drawing it first and then building it. Might not have been a bad idea from the start. LOL
Regards,
ChrisLeave a comment:
-
Automatic update form-fields
Hello every one.
Very new to all this, but trying.
I have a form (payment info). It has a field 'AmountDue', and 5 payments. Then there is the field 'Balance' and 'Status' (see attached screenshots).
Now... I would like the following to happen:
Field 'Balance': Updated -> AmountDue minus the payments.
Field 'Status':
If 'Balance' = 'AmountDue' -> Display "Unpaid"...
No activity results to display
Leave a comment: