Primary Key Issue

  • Thread starter Thread starter gmenon100 via AccessMonster.com
  • Start date Start date
G

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
 
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.
 
Thanks for your quick response. Appreciate it.

Joan said:
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,
Click to expand...
[quoted text clipped - 29 lines]
Message posted via AccessMonster.com
Click to expand...
Click to expand...
 
Back
Top