Please Give Me Feedback On My Table Structure, Will It Work?

[sirantonycartwr]

Hello dear experts!
Will this table structure work? - Please help!
I need to be able to see if certain members have paid subscription, see if stakeholders have paid for their room bookings, etc. Will it work, does it look ok to you?

Im trying to brush up my normalisation skills and logic.

Please click the link below to see my ER-D:



Thanks, Very much, Ant...

 

[GaryPanic]

First glance
Account table
letter sent table (required)
so oyu account table just holds name,address contact details
then you letter sent table could hold 20-30 etc per account rather then the 3 letters and a welcome one
there is a good letter writer in the samples
I personally would have a letter writing form copy default letters in to the letter writer and then once written write them to a letter history table - weird concept but works(and I might of explained this badly- )

the rest looks kinda ok 2 me
g

 

[sirantonycartwr]

Thanks very much for your reply...

Split the stakeholders table into two, One called letters and one called accounts. Ok, i understand what you mean.

BUT...
There are only going to be four letters for each member - ever! So i dont need space for loads more.
If they dont pay the subscription fee they only get three warnings then theyre out! however if they do pay after the first, second or third i can untick the lettersent boxes and they are back to normal. Also, i dont need to keep a record of late payments, it doesnt really matter if their payments are late. (sorry, i didnt make this clear before)

I was going to simply use a query to sift records and just print out reports (which are actually going to be letters telling people that their subscriptions are late).

Thanks very much.
Do you think its ok now? - please tell me if you can find anything else.
Ant...

 

[GaryPanic]

then it looks ok to me .


Why i recommedn the letter option is - as soon as you finish this project , someone will want to change it - so make it as flexible as poss.

g

 

[sirantonycartwr]

ok, how do i do that, ive never done it before, ive only used reports.

ps. Whats it like in Kent now after the earthquake?
Ant...

 

[GaryPanic]

ok - make a copy of your d/b and work on this in case you don't like what we are going to do

right you have your main table Stakeholder
in this you add at least 1 extra field lets call it letterbody
done good

right now you need a letter table and a letterhistory table

in your letter table you need name of letter so
first chaser
and then the body of the text "pay up so swines" etc
second letter
"oi i told you pay up or we send the boys round"
third letter
etc

so your table will have
id . (autonumbver this )name- text
body- memo

now save
make a qry based on this (Don't include the id in your qry)

go back to your stakeholder form add a combo box based on the qry this will now list the letters by name you can use the after update function to fill in the body of the letter from the letter table into your stakeholder form letterbody - now you could now alter just this one letter - or send it out unchanged - now to record your letter into a history table - use append or .add fuction to add your client number to the letter history
this wil have alook like

id number -
client id from your current form
bodytext of letter

you might want to add dates field etc.. but this should outline what i have tried to explain - i'll recap
have standard letters in a table ,- copy this standard letter onto a current form. amend. date stamp whatever send and then copy this data on to a histroy table

from A- to b and finally to C
A= default letter
B= what you want to send out per record
C history of what you have sent

check the samples on letter writers from more insight - there is a very simple one out there that kinda does what i have outlined

 

[GaryPanic]

found a simple one - but this is different from what i have suggested insome eays

 

[sirantonycartwr]

Thanks, Ive had a look and theres a bug in it! Yes, that is a good idea though. I might give it a go. Thanks, Ant...

 

[The_Doc_Man]

I'm going to offer side comments.

You posted the same question (essentially) at least 3 or 4 times. I'm glad someone looked at your work for you. But multi-posting is something that gets you at least a little NEGATIVE attention.

If you don't get a response after a few days, it is just possible that we looked at your problem but either didn't understand it or were annoyed by multi-posting it.

Another thought: This forum is better oriented towards answering targeted questions like, "I do X, Y, and Z. I expect A but observe B. Whassup?" The question of "Please review my work." looks suspiciously like some student hiding behind a fancy excuse to have someone else do the work that will earn the student a passing grade. That isn't what we are about. So that class of question is inherently on our "highly suspicious" list.