467,074 Members | 1,088 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,074 developers. It's quick & easy.

Problem Filtering combo on subform based on M:M

Jerry Maiapu
100+
I have a many to many relationship implemented into a db with 2 parent forms with their respective child forms.

( 3 tables, 1 link table)


for each subform I have a lookup combo on FK Field but combo datasource is based on original PK from table data.

That means data cannot be entered on the subform but is collected from the combo.

One fact is that the same value from the combo cannot be selected again as access will give duplicate errors.

Therefore, once the value is selected from the combo it should diappear in the combo. Else all duplicate values will appear in the combo and will quite be confusing.

I was wondering if there is another approach to avoid such sceneiors.
May 25 '11 #1
  • viewed: 979
Share:
1 Reply
Expert 1GB
Perhaps this insight post by Rabbit will help
http://bytes.com/topic/access/insigh...mbo-list-boxes

Jim
May 27 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Cassie Pennington | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.