Recent content by Ithilien

I'm thinking through the same issues, and in spite of all I've read on newsgroups and in books, the fact remains that a split database may not always be the best solution. Two things I've had to look at very very closely in light of performance issues after splitting: 1. Split database requires...

Is it because you are retrieving both Quantity and Price, and so there will be multiple *combinations* of those values, each combo still being distinct? If that is the case, I don't know off the top of my head how else you would construct the query. As to the item price and AddlQty prices, you...

What I understand Steve's situation to be is a data entry form, where he wants values filled in automatically based on entered values in other fields, where the data being entered refers to orders being placed, and where "Item" is a product ID. So you can have many orders for the same item...

Are your tables linked via the UNC path, or a mapped driver? I prefer the UNC path, but I tried a mapped drive, and it now takes a few seconds for the main form to open, as opposed to 30-60 seconds that it was taking when I was linking through the UNC path.

One way to do this is to write an event procedure for the AfterUpdate event for the "Needed" field. Like: Private Sub Needed_AfterUpdate() If Me![Item] = AP453 Then If Me![Needed] > 100 Then Me![AddlQty] = 25 Me![AddlPrice] = 27.8 Else End If Danny

If you are running the reports from a form, then enter the criteria in an unbound field on the form, and reference that field in the query criteria.