Thanks for the help. I'll see what happens. As for the names, I already did
separate the name into last, first, and middle initial

"Jeff Boyce" wrote:

Lindsay

One more observation...

If you use [Name] or even [ConsultantName], by implication you are storing a
"full name" (e.g., John H. Smith). Your situation may be one of the rare
ones ... but more commonly, sooner or later, someone will want to have a
list of "full names", sorted by last name.

Ahem! You don't have a last name. You have a "full name". How do you get
the "last name" portion of the "full name". Sorry, but that's not very
easy!

It's much easier to separate out FName, MName and LName fields from the
beginning, rather than try to get there from a full name field.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Lindsay" wrote in message
...
I am a VERY novice Access user and attempting to build my company's first
database. I've created three tables to track our consultants:
Consultant Contact information: ID # name, phone number, address, email,
country of residence
Consultant Forms: ID #, name, CV, Biodata, LOC
Consultant Experience: ID#, name, sector, region, comments, languages

Ideally, I would like to be able to create a form with information from
all
three tables into one form, but this hasn't worked each time I use the
form
wizard to generate it. I can generate a form for each table but not the
tables collectively. I currently have the relationship as one to many with
the Consultant contact info as the parent table and the other 2 as the
children. I wanted to link them from Consultant ID # to name in the
children
tables. I can't figure out why the relationship doesn't work and the form
can't be generated. One thing I did notice was that the Consultant ID #s
are
inconsistent between tables despite referring to the same person. The
parent
table starts with an ID # of 2 and I can't change it to one. Could this be
the trouble? I'd also like to be able to create searches by name, sector,
or
language. Any help would be most appreciated.


.