Dropdown list filter

[Andy5]

I have 2 tables. One table has names and each name is assigned a type. The second table is linked to the first one by a unique number assigned to each name. When adding to the second table I want have the user select the name from a dropdown list but only for a certain type.

Ex.

Table 1:

# Name Type

1 Name1 A

2 Name2 B

3 Name3 A

Table 2 will store the number of the name chosen. But during entry of table 2 the dropdown list should only show names of type 'A'

Thanks