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.