View Single Post
  #9  
Old June 5th, 2010, 12:35 PM posted to microsoft.public.access.tablesdbdesign
Jörn Bosse[_3_]
external usenet poster
 
Posts: 20
Default Help needed with table design/layout for newbie

Hi,

thats looks fine. But i would add a location to the sessions table and
for the members maybe a date of birth. But the rest is really ok.
You did a gread job so far.

Jörn


Am 05.06.2010 11:13, schrieb jase118 via AccessMonster.com:
Jörn Bosse wrote:
Yep that looks fine. Remember if you need a field in comination with a
user and sessions, you have to put it in that table.
Any more questions?

Jörn

Am 04.06.2010 23:47, schrieb jase118:
When you setup relations, the fields need the same type: both integer
values. As it seems, your tblSessionMembers is the table to create the

[quoted text clipped - 27 lines]
-logPaid yes/no
-logInstructionsSent yes/no


This is a link to a picture of my tables and relationships, i have attempted
to normalize them and insure the relevant data is in the correct place, let
me know what you think.

http://www.dbforums.com/microsoft-ac...ml#post6463536