471,050 Members | 1,113 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,050 software developers and data experts.

Problem Filtering combo on subform based on M:M

Jerry Maiapu
259 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
1 1063
jimatqsi
1,263 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
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.