I am still struggling with how to prevent duplicate selections being made from comboboxes on a subform.
I have an employee form that has subforms created with the wizard that are based on tables and set to continuous forms and have one combobox on them that lookup data from a lookup table.
However at present someone can select duplicate fields i.e. someone could select 'welder' twice.
I have an 'employee' table that is linked as a 1 to many to the 'EmpTrade' table by 'EmployeeID'. The 'EmpTrade' table has a compound key of 'EmployeeID' and 'TradeID', it also has 'TradeIDNo' as autonumber. The table 'Trade' is linked as a 1 to many to 'EmpTrade' by 'TradeIDNo' and also has a field named 'TradeID'. Table 'Trade Lookup' contains 'TradeID'(primary Key) and 'TradeName'.
I have already tried another members suggestion and still cant seem to get this to work. I am fairly new to Access but learning (hopefully).