473,386 Members | 1,924 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Test Uniqueness and add to table

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
0 1121

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Puvendran Selvaratnam | last post by:
Hi, First of all my apologies if you have seen this mail already but I am re-sending as there were some initial problems. This query is related to defining indexes to be unique or not and...
4
by: Greg Bacchus | last post by:
Hi, I'm just concerned about storing a large amount of items in a Hashtable. It seems to me that as the number of keys in the Hashtable increases, so does the chance of key clashes. Does anyone...
6
by: Andreas | last post by:
Hello list, what about uniqueness of inherited primary keys ? eg you have : create table objects ( id int4, date_created timestamp(0), primary key (id)
2
by: Dirk Declercq | last post by:
Hi, Is it possible in Xml to enfore the uniqueness of an element based on his attribute value. Say I have this schema : <?xml version="1.0" encoding="UTF-8"?> <xs:schema...
1
by: Mr. Almenares | last post by:
Hello: I’m trying to do a schema with recurrent structure for a Book like a Node can have many Nodes inside or One leave. So, the leaves have an attribute that is Identifier. My goal is define...
4
by: wendy | last post by:
Just curious to know if there is a simple way to ensure uniqueness among non-null values within a nullable column. For instance if I have a column of Names that can contain null values, I would...
4
by: Konstantinos | last post by:
I cant find much info or a code on how to do this. I have a generic table called Contact. Then I have tables Person and Company that are subtypes of contact each with attributes that are specific...
1
by: MDS | last post by:
All, I am endeavouring to implement an "Also in the area" feature to an Access 97 DB. Within the table, there are two columns drawn from the same domain - let's call them Place A and Place B....
5
by: Alan Little | last post by:
I have affiliates submitting batches of anywhere from 10 to several hundred orders. Each order in the batch must include an order ID, originated by the affiliate, which must be unique across all...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.