one to many relationship format issue

[Domino2178]

I'm trying to create a database with a one to many relationship. The "many"
table needs to include time data from the "one" table. I created the "many"
table using member SSNs for the primary key, and the "one" table using an
autonumber ID primary key. On the "one" table I created a column that
displays times in the "short time" format that contains only 2 times 08:00
and 13:30. When creating the "one to many" relationship, the 2 times do show
up in the "many' database, however; they are no longer formated as time and I
cannot change this. Access changes them automatically to numbers. This
wouldn't be an issue except for the fact that when I create a parameter
querry to output members that are grouped into one specific time, I cannot
enter the time expression to limit the output records. It brings up a dialog
box stating that the expression is too complicated.

Any help is appreciated.

 

[Steve]

It sounds your tables need revised. Member time should not show up in the
many table .........
TblMember
MemberID
MemberTime (08:00 or 13:30)
MemberFName
MemberLName
MemberSSN

TblManyTable
ManyTableID
MemberID
<whatever fields you need this table for>

Steve
(e-mail address removed)

 

[Jeff Boyce]

If the "one" side table already holds a "time", why do you feel you need to
replicate that value in your "many" side table?

If the "many" record "knows" its parent, it "knows" the time-value of that
parent.

Regards

Jeff Boyce
Microsoft Office/Access MVP