Help with Relationships and Joining Table Info

[rthakral]

Hi, I am a beginning Access user and need some help with a project I am currently working on at my job.



Basically, I wanted to know if it is possible to take information that is under a field in one table and link it to the same field name in another table to duplicate the info rather than typing it manually twice? My boss wants to be able to go back and just edit one so that the other gets updated automatically. Is this possible? If so how do you do it?? Having a lot of trouble with primary keys and all that jazz. I am sorry in advance if this is actually something easy I've tried playing around with it for a while and am failing miserably. Thanks for the help!!

[rthakral]

Please advise: urgent matter!!!!

[Dal Jeanis]

It's not only possible, it's "normal". The data should only be in the database once, on one of the two tables, and you use what's called a "join" between the different tables to get the data to appear together on a single report or form.

Please post the structures of the files. Just list the table name and all the field names and field types. Put the word code in square brackets [] before the list, and /code in square brackets after the list, and that way the forum won't squash the spacing out of your layout.
It'll look like this

Table  MyTable
   ID     Key
   Name   Text
   Age    Number
   Notes  Memo

[rthakral]

So I've joined the tables. i.e. I have a branch name drop down under the committee table and form and I have the same field name under the branch table and form. How do I get the values in the branch name drop down from the commitee table to show up in the branch name drop down under the branch table and form? I formed the relationship, but the drop down shows up as empty in the branch table/form. Please advise. Really pressed for time on this! I've literally never used access before starting this project two weeks ago so I'm a serious beginner. any help would be greatly appreciated. i need really dumbed down guidance as half of this makes no sense to me.

[rthakral]

Bump!!!!!!!!!!!!

[ssanfu]

You need to be more specific.

So I've joined the tables.

Remember, we cannot see your dB, nor can we (AFAIK) read minds. Which tables using which fields???

I have a branch name drop down under the committee table and form and I have the same field name under the branch table and form

Are you using lookup FIELDS in the table defs???

How do I get the values in the branch name drop down from the commitee table to show up in the branch name drop down under the branch table and form?

What is the relationship between the branch table and the committee table?? Is it one to one or many to many?


Pretend like you are standing in line at Burger King. Turn to the person behind you and explain the problem. Post a picture of the table relationship window, your table structure, ....