Hi guys I have a database that needs to have a for as a method for inputing the information about severa products being ordered by customers. here is how I have it set up on a paper order form.
Stocking Shorts
------------------------------------------------------------
size--sm med large xlg sm med large xlg
------------------------------------------------------------
black -black -
brown - -
natural -white -
And customers personal info,customer id,order#,date,type of payment either cod or credit card name,total to be paid,shipment method. I've done a rough design but I am not able to have it perform correctly. Right now I'm inputing the information to the "customers table" because the form I did is not linking properly to the tables. I would like to be able to have the form so that it puts all the information about the products I need to purchase form the dealer. I want to be able to print a table that tells me which product,size,color I need to buy in order to send the customers.I'll apreciate your help I'm stuck.I'm new to access.Thanks
Stocking Shorts
------------------------------------------------------------
size--sm med large xlg sm med large xlg
------------------------------------------------------------
black -black -
brown - -
natural -white -
And customers personal info,customer id,order#,date,type of payment either cod or credit card name,total to be paid,shipment method. I've done a rough design but I am not able to have it perform correctly. Right now I'm inputing the information to the "customers table" because the form I did is not linking properly to the tables. I would like to be able to have the form so that it puts all the information about the products I need to purchase form the dealer. I want to be able to print a table that tells me which product,size,color I need to buy in order to send the customers.I'll apreciate your help I'm stuck.I'm new to access.Thanks
