hi,
i have two forms linked by a command button. so that the form 1 only displays information relative to the particular client in form 2. therefore the foreign key in form 2 is the primary key in form 1(ie my underlying tables have a one to many relation ship) .i set the foreign key control box in form 2 as a look up.
my question is ,how do i restrict the user when adding a record to form 2 to only being able to choose(from the drop down menu) the relevant foreign key to form 1's primary key.
i have two forms linked by a command button. so that the form 1 only displays information relative to the particular client in form 2. therefore the foreign key in form 2 is the primary key in form 1(ie my underlying tables have a one to many relation ship) .i set the foreign key control box in form 2 as a look up.
my question is ,how do i restrict the user when adding a record to form 2 to only being able to choose(from the drop down menu) the relevant foreign key to form 1's primary key.