Form and subform for Transaction

[Business]

Hi guys,


I really need help, i have messed up somewhere but i wonder where. Im bulding a simple inventory system.
As table i got Client(ClientId,ClientName,ClientAdress),Order(ord erId,ClientId,OrderDate),Orderproduct(OrderId,Prod uctId,QuantityOrdered) and Product (ProductId,ProductName,etc...)
On the OrderProduct table both Orderid and productId are primarykeys. the first pb happen on the relationship between OrderProduct and Product.It gives a message while doing the relationship.
And secondly making the form with the wizard gives me a form where i can not interfere with the subform.
How do i go about it,How do i make that form that will be as qn invoice where the issue out of stocks will occurs.
there are screenshots of my relationship and the way the form looks

[orange]

Business,

I'm not sure where you are heading or exactly what you are expecting.
I was trying to assist you, and you created another post with the same subject; and NOW YOU'VE DONE IT AGAIN???

For anyone reading this, please see
https://www.accessforums.net/showthread.php?t=60062
and
https://www.accessforums.net/showthread.php?t=60059

Business, if you are not getting the help you need, or do not understand what you are receiving, then say so. Be more specific in your questions or ask for specific samples.

Creating a new thread with the same topic is not constructive nor efficient.

Watch this free, video tutorial on Data modelling by Daniel Soper.


Good luck.