multiple entries

[Ava]

Hello,

In my relationship window I have a one-to-many
relationship with table Prospect (one) and table
Opprotunity (many). Both are connected through
a "Prospect ID" (text). When I want to enter multiple
opprotunities per prospect Access won't let me. I assumed
that the one-to-many relationship would allow me to do
this. Am I over looking something? Is there any way
around this?

Thanks in advance,
Ava

 

[Ken Allen]

I think your question needs clarification. How are you
attempting to enter multiple opportunities? What error
message do you get when you said that Access won't let you?

One possibility: In the table design of Opportunity, what
properties are set for the "Prospect ID"? I.E., Indexed
property: Duplicates OK or No Duplicates? Would need to
be Duplicates OK.