Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!news-feed01.roc.ny.frontiernet.net!nntp.frontiernet.net!logbridge.uoregon.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: Bellemansmike@hotmail.com (Mike)
Newsgroups: comp.databases.theory
Subject: Relation model in Access, Need some info..
Date: 28 Apr 2003 23:28:57 -0700
Organization: http://groups.google.com/
Lines: 41
Message-ID: <b23399c8.0304282228.38e75e39@posting.google.com>
NNTP-Posting-Host: 217.136.229.12
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1051597737 13198 127.0.0.1 (29 Apr 2003 06:28:57 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 29 Apr 2003 06:28:57 GMT
Xref: core-easynews comp.databases.theory:26032
X-Received-Date: Mon, 28 Apr 2003 23:28:30 MST (news.easynews.com)

Hi everyone

An employee asked me if i could make a form in Access to manage his
custumer's data because now he types all the data in a new Excell
spreadsheet everytime.

The data he wants to document is pretty standard. For example

name
adress
telephone
email
...
Stuff like that is easy i just put it in a table called tblCustumer.

But then he also wants to document the day that the custumer his shop
is open, delivers and is closed.

It's like this in his Excell spreadsheet.

Delivery hours : between 06.30 and 18.00
Delivery days : MON - TUES - FRI
Closingday(s) : SUN
Visiting days : MON - TUES - WED - THU - FRI
Visiting hours : between 7.00 and 17.30

Do you guys know how to make the best case scenario ER.

I was thinking of making a new table called tblWEEKDAYS and then make
connections to it with other tablenames like tblcustvisit,
tblcustclosed, tblcustdeliv. Is this good or u guys have a better
suggestion??

And what do i do with the visiting and delivery hours??

Thanks in advance.

Could u email me a reply because i'm at work and don't have much time
to check the groups.

Greets, Mike