From of a table with two foriegn keys

Occasional Visitor


I have tables tblstationery, tblIndentor. The table tblIssue has two forign keys, StationeryID and IndentorID. I created a form for tblIssue table. It shows both foriegn keys. I can't memorise the primary keys of each stationery and Indentor. I want the form to show corresponding Stationey Name and Indentor Name, instead. How to achieve it. Any help is appreciated. Thanks!

0 Replies