Updating multiple field automatically

[suhaime]

Hi there...

This is my first time asking the question here so bear with me...

I have two tables..
1. Products
2. OrderDetails

The fields in Products are as follows

1. ProductID
2. Product Name
3. unit Price
4. BuyDate
5. SellDate


The fields in OrderDetails are as follows:

1.ProductID
2.Quantity
3.UnitPrice
4.Subtotal
5.BuyDate
6.SellDate
7.OrderDetailsID - Primary
8. OrderID

I want to have the order details form to lookup the values from product table i.e. field 2 - 5. Ive used the dlookup but in the form only the unit price appears but buydate and selldate does not..
the dlookup function is from macro..the code are as follows


DLookUp("UnitPrice","Products","ProductID = " & [ProductID])


any ideas?

[MMcCarthy]

Hi there...

This is my first time asking the question here so bear with me...

I have two tables..
1. Products
2. OrderDetails

The fields in Products are as follows

1. ProductID
2. Product Name
3. unit Price
4. BuyDate
5. SellDate


The fields in OrderDetails are as follows:

1.ProductID
2.Quantity
3.UnitPrice
4.Subtotal
5.BuyDate
6.SellDate
7.OrderDetailsID - Primary
8. OrderID

I want to have the order details form to lookup the values from product table i.e. field 2 - 5. Ive used the dlookup but in the form only the unit price appears but buydate and selldate does not..
the dlookup function is from macro..the code are as follows


DLookUp("UnitPrice","Products","ProductID = " & [ProductID])


any ideas?

You would have to do a DLookup for each value. How do you want it displayed on the form?

[NeoPa]

You need to revisit your table layout.
BuyDate & SellDate should not be fields in the Product table.