Jumat, 18 November 2016

Re: [MS_AccessPros] Table Design Question

 

 Thank You John.

I will put a table in there for the Groups instead of the check boxes. Seems more efficient


Jim Wagner


On Friday, November 18, 2016 8:27 AM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:


 
Jim-

I think the correct way to do this is:

tblEvents:
EventID, EventDescription, etc.

tblGroups:
GroupID, GroupDescription, etc.

tblDates:
EventID, GroupID, EventDate, etc.


John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals 
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
(Paris, France)




On Nov 18, 2016, at 4:19 PM, luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:



Every year in October we calendar for the next year. We have different groups that have events on the calendar that need to be coordinated. Every year we seem to always miss something on the calendar for some reason on another. 
I thought that if I created a database with the events and the dates I could make sure we do not miss anything. 

I figured I would do a events table and then a dates table as a one to many. 

But here is a question. because some groups have events that are comingled, I need the ability to choose the groups associated with the event. My thought was to have a check box for every group. But wanted to know if that was the most efficient way to do it. Is there another way?

I want to be able to have reports that I could show the event and the groups associated with the event. 

Thank You Very Much
Jim Wagner






__._,_.___

Posted by: Jim Wagner <luvmymelody@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (8)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.


.

__,_._,___

Tidak ada komentar:

Poskan Komentar