access link form pls hlp

B

Bagley Crowder

I have two tables:

TBLCustomer:

fldCustID (autonumber primary key - linked as the one in a one-to-many
relationship to TBLOrders, field fldCustID)
fldCustAdd

TBLOrders:

fldCustID (Linked through relationships on many side to TBLCustomer on
field
fldCustID)
fldOrderID (primary key)
fldProduct
fldProductPrice
fldProductQuantity

I want to create a form where I can enter information about a new
customer.
Then I want to have a command button on this form that links to the
Orders
form. On the orders form, I would like it to go ahead and fill in the
fldCustID with the same information from the customer record I just
input.
I.E.
I go into the Customers form, input a new customer, then click the
button to
open the Orders form, and the fldCustID field should automatically
enter the
fldCustID generated for this new customer, from the previous form.

Does this make sense? I can't seem to get much help on what I think
is
probably a basic operation. I am new as you can tell. Please help!
Feel free to contact me at (e-mail address removed). THANKS IN ADVANCE!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top