Hi! ihave a table called titiles. I created a form and the form is in datasheet view whose rowsource is a query from titles table and it displays TitleID. From moving one record to another I want to filter the TitleID. That means I don't want Duplicates.
If there are 5 titles.
If I select Title1, then next record should allow me to select only rest of the four titles. Is it possible?