MS access relationships and ASP

[Sarvesvara BVKS Dasa]

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!.

[Jean Marc Molina]

Hi, > The Dept head at the second table is linked with the EmpId in the first table by means of the relationships.... From your table definitions, I think DeptId is a foreign key that links the Employee to a Department. > NOW, will it be possible for me to access the first table data, by querying the second table. It depends of what you want to do. What do you mean by "access the first table data" ? Do you want to know the employees for a specific departement ? Just a DB design tip : - don't use prefix on your field names : Employee.Id or Department.Id are ok, Employee.EmpId or Department.DeptId/DeptHead is a redondance JM. Molina Web: http://goa.ifrance.com