ASP - ms access relationships querry?!?!
-
HI, I created tables in MS Access.. and am quite familiar in accessing the tables from the ASP page for my site. I then saw somethin like relationships.. and started playing around it. I got the followinf stuff.... Employee (table) - EmpId - DeptId - Name Department (table) - DeptId - DeptHead - Description The Dept head at the second table is linked with the EmpId in the first table by means of the relationships.... NOW, will it be possible for me to access the first table data, by querying the second table. (In access screen I was able to see the first table data in the second table by clicking + on the field which joins them) Please help I was born intelligent
Education ruined me!. -
HI, I created tables in MS Access.. and am quite familiar in accessing the tables from the ASP page for my site. I then saw somethin like relationships.. and started playing around it. I got the followinf stuff.... Employee (table) - EmpId - DeptId - Name Department (table) - DeptId - DeptHead - Description The Dept head at the second table is linked with the EmpId in the first table by means of the relationships.... NOW, will it be possible for me to access the first table data, by querying the second table. (In access screen I was able to see the first table data in the second table by clicking + on the field which joins them) Please help I was born intelligent
Education ruined me!.It looks like it would be more natural to link the Employee table with the Department table on the DeptID field. Best regards, J. Paul Schmidt - Freelance ASP Web Developer http://www.Bullschmidt.com - Creating "dynamic" Web pages that read and write from databases...
-
It looks like it would be more natural to link the Employee table with the Department table on the DeptID field. Best regards, J. Paul Schmidt - Freelance ASP Web Developer http://www.Bullschmidt.com - Creating "dynamic" Web pages that read and write from databases...
Can u throw on some light like... how to do it in the access.. and how to take the data using my ASP pages please... I was born intelligent
Education ruined me!. -
HI, I created tables in MS Access.. and am quite familiar in accessing the tables from the ASP page for my site. I then saw somethin like relationships.. and started playing around it. I got the followinf stuff.... Employee (table) - EmpId - DeptId - Name Department (table) - DeptId - DeptHead - Description The Dept head at the second table is linked with the EmpId in the first table by means of the relationships.... NOW, will it be possible for me to access the first table data, by querying the second table. (In access screen I was able to see the first table data in the second table by clicking + on the field which joins them) Please help I was born intelligent
Education ruined me!.Off the top of my head, select * from Employee, Department where Department.DeptId = Employee.DeptId Michael 'War is at best barbarism...Its glory is all moonshine. It is only those who have neither fired a shot nor heard the shrieks and groans of the wounded who cry aloud for blood, more vengeance, more desolation. War is hell.' - General William Sherman, 1879
-
Off the top of my head, select * from Employee, Department where Department.DeptId = Employee.DeptId Michael 'War is at best barbarism...Its glory is all moonshine. It is only those who have neither fired a shot nor heard the shrieks and groans of the wounded who cry aloud for blood, more vengeance, more desolation. War is hell.' - General William Sherman, 1879
hmmm... my question was different... In my case.. I had setup the relationship in the ms acces itself. And, I use that through the ASP page. All I want to know is... how can I get the calue from the second table, when I make the connection/record_set on the first table (both tables are linked by the relationship in access?!?!)... I was born intelligent
Education ruined me!.