By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,080 Members | 1,845 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,080 IT Pros & Developers. It's quick & easy.

Test Uniqueness and add to table

P: n/a
I am writing an Access 2000 program for scoring an athletic tournament.

I have a Members table (tblMembers) that contains Member information like
Name, Address, Member Number. Member Number is unique and is the Primary
Key.

I also have a Competitors table (tblCompetitors) . It contains a Competitor
Number and Member Number. Competitor Number is unique and is the primary key
and is auto number.

I want to select a member from tblMembers.

If the member is not in the tblCompetitors then I want to add this
competitor to tblCompetitors.

If the member is in the tblCompetitors then I will just pop up a warning
and let the user try again.

I think I should open a combo box populated with the tblMembers and let the
user select a member and then either add the selected member or warn that it
already exists.

It's easy enough to open the Members Combo Box (cmboMembers) but I can't
figure out how to test and add to the tblCompetitors table.

I would appreciate any help.

Please note I am somewhat of a newbie so If there is more than one approach
, I would prefer the simpler one.

Thanks .
Jul 14 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.