copying a field value to another table with a form

  • Thread starter Thread starter Maarten
  • Start date Start date
M

Maarten

Hi,

Can anyone tell me how I can put a repliclation Id, that's visible on
form, into a field from a selected record in another table?

The case is this: I have a table Customers, and a table Items. Now
want to enter a new customer and attach one or more selected items t
that new record. Aftering entering the customer details, I'd like t
perform a search, to get the ordered item(s). Then I'd like to make
connection between this customer and the item based on the custome
Id.
I tried to reach this with a button on a form that activated an updat
query but that didn't work out.

I hope anyone can help me with this! Thanks...!

Maarte
 
First I'll recommend that you examine the Northwind database that ships with
Access. It has an order entry system.

Next, you'll need to add a table to your structure that holds the Orders and
Order Items.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top