Originally Posted by
ranman256
The main form, say Clients ,should show 1 record.(with the ClientID field on the main form)
the sub form, say purchases, should be a continuous or datasheet,
you can bind subform to the TABLE, tPurchases. (you can use a query, but dont need)
make sure the field, tPurchases.ClientID, is on the subform
in the subform properties, data tab,
LINK MASTER FIELDS= ClientID
and
LINK CHILD FIELDS = ClientID
now only records you will see in the subform will belong to the client in the main form.
the only records you add will belong to that client.
(you can hide the subform ClientID field if you want.)