-
Hi guys,
i have an access table with the following fields Name,p1,p2,p3
p1,p2,p3 are the preferences.
a user can have an entry in the table with his name & preferences in any order.
What i need is to fill u pa combo box with the Unique preferences from p1,p2,p3.
repetetions cannot occur in a single row but they may occur in a column.
Any help will be welcome.
Regards
Jaspal
-
I would error check the p1,p2,p3 fields before writing the data.
If p1 = p2 then nodatawritten
elseif p1 = p3 then nodatawritten
elseif p2 = p3 then nodatawritten
else
write data
end if
I don't know of a way to error check w/sql.
Hope this helped
