Hello,
I have a many-to-many relationship between two tables, which has a join table. Would it be possible to do the following:
Take a user selected primary key from a list (or combo control) control (we'll call it key-A) from the first table, query the join table with key-A and find all primary key values assocated with key-A which belong in the second table (we'll this set, keys-B). At that point, I would like to use keys-B to open a form (filtered) that displays the fields associated with keys-B.
Is this possible?
I'm using Access 2000 with SQL Server as the backend (Access Project instead of an actual Access Database). What I need to know is not how to create the form elements, but rather, if I should use form filters to achieve this.
Thanks,
Nishant
I have a many-to-many relationship between two tables, which has a join table. Would it be possible to do the following:
Take a user selected primary key from a list (or combo control) control (we'll call it key-A) from the first table, query the join table with key-A and find all primary key values assocated with key-A which belong in the second table (we'll this set, keys-B). At that point, I would like to use keys-B to open a form (filtered) that displays the fields associated with keys-B.
Is this possible?
I'm using Access 2000 with SQL Server as the backend (Access Project instead of an actual Access Database). What I need to know is not how to create the form elements, but rather, if I should use form filters to achieve this.
Thanks,
Nishant
