Re: Relationships

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Lisa

It sounds like you are saying "one Client can have many Candidates" and "one
Candidate can be associated with many Clients". If that's an accurate
statement, you need THREE tables, not two, because you have a "many-to-many"
relationship.

Your tables, in that case, might be something like:

tblClient
ClientID
(client-specific info)

tblCandidate
CandidateID
(candidate-specific info)

trelClientCandidate
ClientCandidateID
ClientID (serves as a foreign key to point back to tblClient)
CandidateID (serves as a foreign key to point back to tblCandidate)
(other info specific to this combination)

That third table lists valid combinations of client and candidate.

You'll want to first get the data modeled appropriately, then start work on
forms to display it...

Regards

Jeff Boyce
Microsoft Office/Access MVP



"Lisa Cowan" <LisaCowan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:52F0EFC7-0A5D-46CB-9075-A95EFCD767A8@xxxxxxxxxxxxxxxx
I am creating a DB for a recruitment agency, so it will hold all our
clients
records and all the candidates that have worked for them.
I have a Clients form which combines fields from 2 tables Clients tbl and
Candidates tbl as a subform on the second page (tab control). When I go to
complete the second page of the form, I get an error message saying
basically
I need to complete the information in the Candidates tbl before I can
amend/create this record. I realise it is a referential integrity issue I
have but after thinking about it so long I am not to sure if I am in a
relationship or not never mind the DB!
I think it is a one to many relationship but because of the error I am
getting I think it could be a many to many.
One client can have many Candidates, some times the same Candidate more
than
once but a Candidate can also work for more than one client so is it one
to
many or is it many to many? Or should I leave it as one to many but drop
the
ref integ?
Probably really stupid but help is much appreciated.
Thanks


.

Relevant Pages

  • Richmond Jobs Update 01/10/05
    ... I WILL ACCEPT OUT OF STATE CANDIDATES ... PROVIDING THEY HAVE ALL OF THE SKILLS REQUIRED! ... Location: Richmond, VA ... My client is in need of a Data Analyst/Documentation Specialist. ...
    (comp.lang.java.programmer)
  • Re: Intermediate Fact Table
    ... business, the can be n number of participants from different ... dimensions linked to the same fact record. ...  Let's go back to my first example: The client is ... sent CV's of 50 candidates in one transaction. ...
    (microsoft.public.sqlserver.olap)
  • ADMS Modeller: 2-3 years experience Excellent Remuneration (UK Nationwide)
    ... Salary: Commensurate with Experience ... The client, a well know and respected UK based environmental ... consultancy is looking for a skilled and enthusiastic consultant to ... Interested Candidates should apply with a covering letter and current ...
    (sci.geo.meteorology)
  • REQ:C#DOT NET Developers for 10 positions
    ... basically a solid mid to senior level .NET developer. ... My problem is that the candidates need to roll over FT to the client ...
    (comp.lang.smalltalk)
  • Re: [Full-disclosure] [inbox] Re: Supporters urge halt to, hackers, extradition to US
    ... So basically what you're saying is that we should all shut up and not ... and that trolls should be trolls and stay ... FIN (when server to client) = Time for you to leave. ...
    (Full-Disclosure)