Hello all!
I have a client who builds displays for windows and doors, etc. I have set up their order entry to choose the fixture (display) and then choose the products (windows/doors) to go into it. They are moving from a dreadful Xcel spreadsheet and are used to seeing things a certain way . So in the order form, the fixture has to be bold and the products under it, not in bold. This works great, until they realize that they forgot to add a line item product. Of course, you can't just insert it where it should be, so I came up with a sequential numbering routine, the basic:
Code:
Forms![Orders]![BuildItfloor].Form![OrderDetailsfloor]!LineNum= Nz(DMax("LineNum", "OrderDetailsFloor", Storenum=[storenum]), 0) + 1
, so when they add an out of order piece they can change the LineNum to something that puts it in with the other related items. Clear as mud? This works great in one section (first image), but there are other displays that it's necessary to autofill pieces that go with them, using a query. Again, fixture needs to be bold and products not. Sequential numbering does not work in this instance (second image). Any tips on how I can get it to work? Images attached. I thank you in advance for any help you can send my way.