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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 | |
|
|