Primary Key Issue

[gmenon100 via AccessMonster.com]

Dear Friends,

I have a access project having 2 tables. tblpurchase: with PuchID, Purdate,
PurchAmt, EmpID

TblEmployee with EmpID, EmpName ......

EmpID is a foreign key in tblpurchase from TblEmployee

When you open the employee table and click the "+" it lists all purchase made
by the employee. Alls well here.

My problem:

I added another table : tblAttendance with AttID, AttDate, AttdType, and
EmpID where EmpID is the foreign Key connected to the tblEmployee. But now
when the "+" sign in the Employee table is clicked, it prompts for a
subdatasheet.

My question:

Can I see both the tblattendance, and tblpurchase when the "+" is clicked.

Appreciate your response.

Thanks

Gmenon

 

[Joan Wild]

No you can't. You can only see one subdatasheet at a time. If you want to
see both you should build a form with two subforms.

You should also consider changing your table design to not show any
subdatasheets on any table.

 

[gmenon100 via AccessMonster.com]

Thanks for your quick response. Appreciate it.

No you can't. You can only see one subdatasheet at a time. If you want to
see both you should build a form with two subforms.

You should also consider changing your table design to not show any
subdatasheets on any table.

Dear Friends,

[quoted text clipped - 29 lines]

Message posted via AccessMonster.com