multiple entries

A

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
 
K

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
one-to-many relationships 2
Weekly Report 2
Embed the same Excel multiple times 0
Data entry Form - confused and lost 9
Update primary Key. 1
primary key - concatenated or autonumber? 6
how to display data from Table 1 ("one") in Form for Table 2 ("man 4

Top