Get specific record given the 2 primary keys

[kismet]

Hello! How can one program an access database in such a way that it takes in the chosen values of the 2 primary keys and displays the record (in form view) pertained to by those 2 primary keys?

I hope this question made sense... thanks!

 

[MichaelRed]

A[tab]Some confusion / details missing? To refer to "2" primary keys would appear to need to be also refering to 2 tabletype recordsets, as "primary key" is unique to a table.

B[tab]Finding a record diepends (somewhat) on the version of Ms. A. and the data-access methodology chosen. In Ms. A. '97 and earlier, this has a default (DAO, for '97). In ver 2K and later there are choices / selections and even when one is selected it needs to be explicitly referenced in declarations,

C[tab]Once "A" and "B" are somewhat clearer, 'Help' becomes helpful, perhaps starting with "find" or "seek" as key words.

D[tab]Once a record is 'found', in an appropiate recordset, an easy approach to actually having a form display information from the specific record is to set the form's bookmark to the corresponding ('appropiate') recordset's bookmark for that record.

E[tab]The above, of course, assumes that you would use 'programming' to locate the record, but there are alternate approaches, such as filters which may suit your needs. "Filter" is also found in "help", and may provide some enlightenment.



MichaelRed
m.red@att.net

Searching for employment in all the wrong places