HELP!!!!! need help in programing a button.

  • Thread starter Thread starter Elbe
  • Start date Start date
E

Elbe

I am new to programming and would appreciate any help I can get.

i have a form(continuous) called parts with the following fields part
number, part name, Qty and cost

i would like create a button on the parts form that when pressed would add
the parts name and information to another form called customers which has
the (sub form)called customer parts which also has a field called parts name.

can anyone show me step by step on how to do this
thanks
If you need additional information please let me know
 
I am new to programming and would appreciate any help I can get.

i have a form(continuous) called parts with the following fields part
number, part name, Qty and cost

i would like create a button on the parts form that when pressed would add
the parts name and information to another form called customers which has
the (sub form)called customer parts which also has a field called parts name.

can anyone show me step by step on how to do this
thanks
If you need additional information please let me know
Click to expand...

First off... you CANNOT "add a record to a form". Forms are just windows; they
don't store any data! The data exists in Tables, and only in Tables.

Also, if you're trying to copy part name, etc. from one table into another
table... don't. Storing the information redundantly is essentially NEVER a
good idea. You should certainly NOT have a Parts Table and a duplicate
CustomerParts table!

Let's start with the basics. What Tables do you have? What are the relevant
fields in the tables (particularly each table's Primary Key)? How are the
tables related?
 
What I have is the following tables
products
order details
orders
customers

the relational links are as follows

customer to orders 1 to many [ customerID] to [ customerID]
orders to order details 1to many [order id] to [order id]
order details to products 1 to many [productsID] to [products ID]

right now i have a combo box in the sub order form called product that adds
the product to the order

what i would like to do is get rid of the combo box

and to be able to pull up the products form (listing all the products with a
pic of the
products)
and enter the quantity that the customer wants and have it add it to the
customers order and then be able to save it for future reference
If this cannot be done is it possible to add a button on the continuous
parts form that will add it to the customers order? if so how do i do this?
 
Back
Top