How do I change a relationship from a O-2-M to O-2-O?

[Guest]

For my employee database, I think I have managed to crack my table
relationships. This is the way I have it set up in the relationships box from
left to right (which I hope will make sense!):

Employee:

Name (PK: 1)
Work
Status
Rate

Date

Name (Many)
Date (PK: 1)

Link

Date (PK: Many)
Dept (PK: Many)

Dept

Dept (PK: 1)
Subdept (many)
Cost centre

Hours

Subdept(PK: 1)
Standard
timehalf
double

I have created a form with two subforms. The main form is for employee
information, the first subform is for date and the second subform is for
department and hours information.

I am fairly sure this is what I want. The only issue I have is that I
thought that in the "date" table I would want many dates, but I think I only
want a single date.

help appreciated, thanks in advance.

 

[Guest]

I am also getting the following error:

"The microsoft jet database engine cannot find a record in the table 'hours'
with key matching field(s) 'subdept'".

So maybe some of the wisest of you can have a look at my relationships to
see where the problem might be.

thanks

 

[Immanuel Sibero]

Scubadiver,

A couple of people have offered very viable solutions to start with in order
to solve your *challenge*. Did you not understand them? If not, you should
follow up in that same thread. You're posting the same question and you're
most likely getting the same answer, if at all.


Immanuel Sibero