Help to avoid the reptyping of same data multipley

[moonshaker007]

hello
can any one help me on this

i have the table of recipent invoice now the problem is that vendor will send the diffrent invoice in diffrent courrier and diffrent dates now i want to track the that invoice no with courier doc no so i had created a table invoice recipent in that i have fields
1) date of recipent
2) courier docket no
3) sender name
4) invoice no

Now the problem is the 4) invoice no is diffrent value but 1) date of recipent,2) courier docket no,3) sender name are similiar value, so my maximum time will go with updating this 3 field so i need solution up date this faster. can any one guide me how can i create this by using forms like creation of subform for same table fields.

Like 1,2,3 fileds will be header and 4th field must be like subform to enter the multiple value at a time.

Regards
Chandra Shekar

 

[kipcliff]

Typically, an invoice is the main form, and the details are the subform. Courier and sender (customer?) would be lookups for Invoice.

tblInvoice
pkInvoiceID
fkCourierID ... lookup from tblCourier
fkSenderID ... lookup from tblSender
.
.
.

tblCourier
pkCourierID
CourierName
.
.
.

tblSender
pkSenderID
LastName
FirstName
Address1
Address2
.
.
.

qryInvoice
tblInvoice.pkInvoiceID
tblInvoice.fkCourierID
tblCourier.CourierName
tblInvoice.fkSenderID
tblSender.LastName
tblSender.FirstName
.
.
.

When you select a courier or sender, the related fields will also fill, automatically.

Make your main form from this query, and the same autofill behavior will occur in the form.