Subject | Grid lookup |
---|---|
Author | Dion |
Post date | 2002-01-20T13:56:31Z |
Hi all,
Is it possible to have a lookup on a field in a "joined" table. For example,
if MemberBen is the table representing the relationship between a Member and
his Beneficiaries, and titleid is the foriegn key in the Beneficiary table,
how do you get a drop down in for eg a grid, of all possible titles from the
Title table. There seems to be a problem declaring KeyLinks for the lookup
query.
Many thanks,
Dion
Is it possible to have a lookup on a field in a "joined" table. For example,
if MemberBen is the table representing the relationship between a Member and
his Beneficiaries, and titleid is the foriegn key in the Beneficiary table,
how do you get a drop down in for eg a grid, of all possible titles from the
Title table. There seems to be a problem declaring KeyLinks for the lookup
query.
Many thanks,
Dion