T
Tony M
Hi all. I have a form with a subform on it. The parent form is based
on a table with a two field primary key, consisting of a lot number
and a truck number. The subform is in a one to many relationship
based on lot number and truck number. In the properties of the
subform, I have set Link Child Fields and Link Master Fields to Lot
Number;Truck Number.
However, when a user tries adding a new record and types in a truck
number in the parent form, the subform brings up records that match by
truck number, but with a different lot number. Why is this? Is there
a way to prevent this?
Tony
on a table with a two field primary key, consisting of a lot number
and a truck number. The subform is in a one to many relationship
based on lot number and truck number. In the properties of the
subform, I have set Link Child Fields and Link Master Fields to Lot
Number;Truck Number.
However, when a user tries adding a new record and types in a truck
number in the parent form, the subform brings up records that match by
truck number, but with a different lot number. Why is this? Is there
a way to prevent this?
Tony