Duplicates

[jz]

Hi. I have an asp showing dupes for state id.

I have one small table that has state id and another col for the state name.
e.g. 1= OH

In my main table, and this is in Access...I'm a novice but figured i had to
link the main table of users with this state table, so...

In my main table, i had state id as pri key, but now i have another user
from that state, so it wouldn't let me add teh state id without allowing
duplicates. i'm not sure if that is causing the asp issue, but my guess is
yes.

So, how do i allow myself to add dupe state id's in the main table, in order
that i can have more than one user from teh same state, yet limit my asp
using fp dbrw to show only one state per stae id?

thx.

 

[jz]

ok, the other thing i can tell you is that for this asp, I use for the source
an Access query. The query uses both tables, which links by state id.

When I look at the query, I see the duplicate records for the 2 people with
the same state. I'm wondering if there's soemthing within the query design I
might need to handle the duplicate of the states on my asp.

thanks.

 

[jz]

also, i'm sorry..I forgot to mention that I don't have the primary key issue
anymore. It was an asp filter i needed to set, so I can now keep my state id
as primary key and just allow duplicates.

My currenr question is the one I just posted before this, which is...how to
stop the duplicates on my asp...would it be to edit my source, which is a
query? thanks.

 

[jz]

Please disregard...I figured it out.

thx. -jz