I
injanib via AccessMonster.com
I have a form called "frmInvoice". The field does not have an autonumber
field, however it has a field called "txtInvoice" which is for the invoice
numbers and is uniquely generated.
In this form is a subform called "frmDescription". This form is in multiple
format and is where I enter the description of items such is qty, unit price,
total etc... There could be multiple records in this subform for the same
invoice number in the parent form.
I would like to link the subform to the main form such that when I open a
specific invoice, it also shows the related items in the subform. This
information will later be translated to a report.
I tried creating a new field in the table and form of the subform and set its
default value to that of the "txtInvoice" of the main form and used that
field to link, but I am not sure if I did it right. I am not sure what the
"Link master field" and "Link child field" under the Data tab of the
subform's property do.
How can I accomplish this.
field, however it has a field called "txtInvoice" which is for the invoice
numbers and is uniquely generated.
In this form is a subform called "frmDescription". This form is in multiple
format and is where I enter the description of items such is qty, unit price,
total etc... There could be multiple records in this subform for the same
invoice number in the parent form.
I would like to link the subform to the main form such that when I open a
specific invoice, it also shows the related items in the subform. This
information will later be translated to a report.
I tried creating a new field in the table and form of the subform and set its
default value to that of the "txtInvoice" of the main form and used that
field to link, but I am not sure if I did it right. I am not sure what the
"Link master field" and "Link child field" under the Data tab of the
subform's property do.
How can I accomplish this.