View Single Post
  #8  
Old June 5th, 2010, 10:13 AM posted to microsoft.public.access.tablesdbdesign
jase118 via AccessMonster.com
external usenet poster
 
Posts: 3
Default Help needed with table design/layout for newbie

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


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201006/1