Hi everybody in this forum!
I am a brandy new member.I get used to working with access 2000.I am building a programm of managing my personel.I have done 1 table in datasheet with full CV information of every members.Now I have built one more table about projects. Now I want to link 2 these tables to show the projects that every member has taken apart.The table"projects" include ID project,project name, begindate, enddate,project description.All I want is how to link these tables so that when I call one member, I can see all information about this one.
1) to have defined columns (fields) in both tables that are the same datatype. usually in a realtional table design the foreign key will be on a numeric integer/long datatype. if you use access in built autonumber datatype that is long integer.
2) open up the realtionships window Tools | Relationships, all relevant tables to the diagram. click (and hold) the column in the table that is the 'parent', then whilst still holding drag the pointer to the child table, release the mouse button, and define the columns and detail appropriately. Generally I'd reccomend that you select "Enforce Relational Integrity", whether you choose to allow cascade deltes or updates is up to you.
but then if you had looked at the help system you would have know all about this. It took a few iterations (starting off with relationship) to come up with this in the search tab
"About relationships in an Access database"