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