I'm sorry If I have faults in writing , Because My English isn't perfect
I have some invoices in Table : 1- Sales invoice , 2- buy invoice , 3- Returns by customers , 4- Returns to the producing companies , 5- damage
I made these 5 Tables for head of invoice ,,, and also I made 5 sub Tables for these 5 head invoices
and also I have these tables : Goods name , costumers name , Productions name , expenses ....
How I will make relationship between them ? ,,, and When I make A computational operations in Query for these Subform , I should use these Queries for reports , I can use it for Forms ,,, When I bring them to Forms it says me , you can't enter any data ,,
for Example : in subform I have ( Number , Goods name , Quantity and Price ) When I make Total for it , It's okay
But I can't use it for Forms .
and When make Relationship for these five Tables , Even show me Store , It's tells me , you should Movements to all bills even show you Store , ( for example : I bought something from one Production company and When I enter those data in buy invoice it isn't appear in Store , I should enter those data in these 5 invoices even it;s gives me right store )
and I have a problem with costumers ,,, When I enter costumer's name in invoices , His Mobile and Address isn't appears .
If anyone can help me , I will be very glad .