A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Creating Relationships



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old April 2nd, 2010, 05:17 PM posted to microsoft.public.access.tablesdbdesign
Lindsay
external usenet poster
 
Posts: 76
Default Creating Relationships

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.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:40 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.