Data entry form

[kkbharat]

Hi All,

I have a data entry form with main form and a subform with one to many relationship in it but because there are multiple record on the many side of the table the number of records shown in the form are more (because of the join type). What I am trying to achieve is that this form should have records only matching with the first record on the many side of the table.

I tried by making a subquery which calculates the first entry and then connected this with the main query of the form and this way I am able to achieve what I am expecting but then I am not able to make data entries.

Can someone please help.

Thanks !!!

[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.)

[kkbharat]

Sir, thank you very much for your response. I am trying to keep the new data entry and the one with continuous form separate but then what you suggest is the easiest way to deal with my requirement.

Thank you very much once again.

Bharat

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.)