[RESOLVED] Need Urgent Help Access Form....

[nileshhthakur2004]

Hi all,

i have tried no of thing's to Populated the Relation between the no of form but it's Won't help me ....
pls help me any one my requirement is as follows
i have three table as
Customer,
OrderHeader,
SubOrder,

in Customer table i have two filelds CustomerID,CustomerName
in OrderHeader table i have OrderNbr as primary key and CustomerID as Foreign key and other column also, in SubOrder table i have filed name subOrderNbr as primary key and OrderNbr as foreign key from OrderHeader table using this info i want to genrate form for Select one CustomerName from DropDown and place one order (SubOrder also) for that customer pls send me sample Db using your Filed name and othere info..

thanx and Regards,

[RobDog888]

It sounds like yoiur db design may need some rethinking.

You may be better having a Customers table and a Orders table. I dont see the need for splitting the orders up the ways you have?

[nileshhthakur2004]

Hi robdog
thanx for you responce, i have three table's one for "Customer" one for "Order" table and one for "Ordersubtable"

"Customer" Table
in customer table it contain the fileds as follows
this table is use for store the customer name and ID only

CustomerId primarykey
CustomerName

Order Table
tihs table is use for trace the order for perticular customers

OrderNbr primarykey
CustomerID foreignkey
OrderAddress
--------
--------

"OrderDetail" table

this table is use for trace the item in perticular order
suppose one customer place ordre with number of items..
so OrderDeatil table is use for that ...

OrderDetailID PrimaryKey
OrderNbr ForeignKey

so if i want to relate all this three table then need to write query for that ..

My Question is that if you are able to show me how can i place one order for perticular customer by selecting customer name from dropdown and all data should save in each table ??

pls help me by sending sample db or code i have search all try your sample DB also but not solve my issue

pls help me regarding this ..

Thanx and Regards,

[RobDog888]

OrderDetail is not necessary and all info about the order should be in the Order Table.

Customer
---------
CustomerId primarykey
CustomerName

Order
---------
OrderNbr primarykey
CustomerID foreignkey
OrderAddress

Is about the minimum of what you need.

[nileshhthakur2004]

hi ROBDog,

i am sending you my DB with three Table pls see it, using this DB i want to place the order for perticualr client
thanx and regards,

[KGComputers]

Hi,

Based from the .zip database file, you don't have relationships defined...I guess you need to relate your tables with one another...Say, Order headers relates with ordersubtable, customer relates to orderheader, products relates to orderssubtable...

[nileshhthakur2004]

Hi KGComputer,

thanx for your help i have set Relation between by Tabls in DB and using some codding now my problem is get solved thanx onece again..

thanx and regards,

[KGComputers]

Hi,


Glad to be of service....

Your welcome....