Tranfer Data from Combobox lookup to new record in another table

2- Tables Customer & Invoice
Customer has typical ID,Name, street, etc
Invoice is special type has about 29 fields and needs to import the id,
name, street, etc to this table. Save the total data..
When the record is complete it will print onto a specialized multipart
invoice.
I setup a form for the invoice and lookup customer id, -- Now I need to
transfer the data from the lookup to fields in the invoice table..


I can supply copies of the files if you need to see them..

re: Tranfer Data from Combobox lookup to new record in another table

Is your customer information subject to frequent change? If not, simply
include a foreign key to the Customer table, and pick up the information
with a Query when you need to use it.

If it is subject to frequent change and needs to be saved "as of this point
in time", include controls on the form bound to the fields into which it
must be saved, and set them in VBA code in the AfterUpdate event of the
Combo Box. These fields can, if you wish, have their Visible property set to
No, or can be left Visible to allow the user to see exactly what is going to
be saved.

Larry Linson
Microsoft Access MVP

"JC Mugs" <jcmugs@hotmail.com> wrote in message
news:vv8ojgukk2410@corp.supernews.com...[color=blue]
> 2- Tables Customer & Invoice
> Customer has typical ID,Name, street, etc
> Invoice is special type has about 29 fields and needs to import the[/color]
id,[color=blue]
> name, street, etc to this table. Save the total data..
> When the record is complete it will print onto a specialized multipart
> invoice.
> I setup a form for the invoice and lookup customer id, -- Now I need to
> transfer the data from the lookup to fields in the invoice table..
>
>
> I can supply copies of the files if you need to see them..
>
>[/color]

re: Tranfer Data from Combobox lookup to new record in another table

"JC Mugs" <jcmugs@hotmail.com> wrote in message
news:vv8ojgukk2410@corp.supernews.com...[color=blue]
> 2- Tables Customer & Invoice
> Customer has typical ID,Name, street, etc
> Invoice is special type has about 29 fields and needs to import the[/color]
id,[color=blue]
> name, street...[/color]

No it doesn't. It needs to link to Customer. In your Invoice table design
insert a field called CustomerID, or somesuch. In the relationships window
of Access create a one to many join from Customer to Invoice.

Then do a query to give you the information you need.

YOurs, Mike MacSween

re: Tranfer Data from Combobox lookup to new record in another table

Beg your pardon. Larry's right. If you want to store 'where this customer
was when this invoice was raised' then you'll have to do it as per his 2nd
paragraph.

Mike

"Larry Linson" <bouncer@localhost.not> wrote in message
news:c5_Ib.36437$E17.22496@nwrddc02.gnilink.net...[color=blue]
> Is your customer information subject to frequent change? If not, simply
> include a foreign key to the Customer table, and pick up the information
> with a Query when you need to use it.
>
> If it is subject to frequent change and needs to be saved "as of this[/color]
point[color=blue]
> in time", include controls on the form bound to the fields into which it
> must be saved, and set them in VBA code in the AfterUpdate event of the
> Combo Box. These fields can, if you wish, have their Visible property set[/color]
to[color=blue]
> No, or can be left Visible to allow the user to see exactly what is going[/color]
to[color=blue]
> be saved.
>
> Larry Linson
> Microsoft Access MVP
>
> "JC Mugs" <jcmugs@hotmail.com> wrote in message
> news:vv8ojgukk2410@corp.supernews.com...[color=green]
> > 2- Tables Customer & Invoice
> > Customer has typical ID,Name, street, etc
> > Invoice is special type has about 29 fields and needs to import the[/color]
> id,[color=green]
> > name, street, etc to this table. Save the total data..
> > When the record is complete it will print onto a specialized[/color][/color]
multipart[color=blue][color=green]
> > invoice.
> > I setup a form for the invoice and lookup customer id, -- Now I need to
> > transfer the data from the lookup to fields in the invoice table..
> >
> >
> > I can supply copies of the files if you need to see them..
> >
> >[/color]
>
>[/color]