price – invoise (2k)

Topic

New Reply

Hello all
1- I have 3 tables ( 1st = tblsabic , 2nd = tbltrans , 3rd = tbltrans1)
2- There are a relation between tbltrans and tbltrans1( D/no)
3- tblsabic contain 4 fealds ( items

Reply | Quote

Replies

You say that there is a relationship between tbltrans and tbltrans1 on D/no, but D/no is not in the list of fields of tbltrans1. Without a link between tbltrans and tbltrans1 there is no way to do what you want.

Reply | Quote

sorry i forgot to write it .
good notc

Reply | Quote

OK.

Should the user be able to change the price in tbltrans1 after it has been set automatically, or is the price in tbltrans1 completely determined by the price in tblsabic?

Reply | Quote

the price in tbltrans1 completely determined by the price in tblsabic

Reply | Quote

You can calculate the price in a query; there is no need to store the price in tbltrans1, since it is a derived value. See attached database.

Reply | Quote

it is good but i want to store the prises in tbltrans1 couse i change these prises evry 3 monthes , also if is able the user change it .
thanks

Reply | Quote

You will have to do this in a subform based on the tbltrans1 table (the main form will be based on tbltrans). Change the price in the After Update event of the Item text box:

Private Sub Item_AfterUpdate()
Me.Price = CCur(DLookup(“Price”, “tblSabic”, “Item='” & Me.Item & _
“‘ AND Date1=#” & Me.Parent.[Date] & “#”))
End Sub

See attached database.

Reply | Quote

That is ok Now .
Thank u very much .
Ashraf

Reply | Quote