Recent content by mergle

Very nice and good changes. Thank you. The end user is currently sending Excel spreadhsheets to each supplier for their order with only material quantity needed...and no pricing. However I thought about this regarding NEW price increases from vendors and how that affects existing records with...

Pat Hartman, I didnt see this before my last post. Locking up the Vendor cbox is what I thought about doing. Is making all material item record refresh with the correct pricing, once a Vendor is changed, too complicated?

OK, its good to know I wasn’t totally off base. I think its the tblPOVendorMaterial join table utilizing the join table from the VendorMaterial that makes it look circular? Thank you. OK, I probably dont need all the fields I think I do, so I will look at again. I had previously tried to...

OK, attached is my sample db. Hopefully you can make sense of what I am trying to do. Yes, I am trying to use the cascading type combobox for the material selection. Thanks

Trying to make sense of it, so thank you for your patience. Also not sure how to perform the data validation you mention. With my current design the materials combobox shows vendor-specific materials based on the vendor combobox selection. Once I add material items under one vendor, and then...

Wouldnt that require a VendorID to be selected for every record in the subform? Since a purchase order can only be associated with one vendor, seems your method would allow a different vendor on each material record. I want the database to be designed and structured properly, so I am just...

I know it's probable that I am missing a basic principle somehwere, but after a lot of thought and trial it seems I would need the VendorID in tblPurchaseOrder as a FK. As purchase orders are a 1-M with vendors, wouldn't I need the VendorID field stored in tblPurchaseOrder?

OK, I will work to use the unbound combo box. Other than that do you see any problem with using the tblVendorMaterial join table for the tblPOVendorMaterial join table?

OK, however I want the VendorMaterialID items to be a datasheet subform to show only vendor-specific material pricing for a given material item selected based on the VendorID that's selected on the purchase order main form. So, wouldnt I need the VendorID at the main form level to show these in...

Hello, I haven't designed a database in many years and struggling with different scenarios for days with what seems should be easy to see, but not sure if I am able to. I now feel that I know enough to be dangerous. The database is for a home exterior cladding subcontractor that performs work...

I am need of tracking previously drawn lottery numbers. Would it be best to have the drawn numbers be entered as separate fields in a given record (i.e., Ball1, Ball2...Ball5), or to create a one-to-many join table between a tblBall.BallID and a tblDrawings.DrawID? I am vacillating back and...

I have a subform (Datasheet mode) on a main form (Single form mode). I normally just use the wizard to create a combo box to find a record on a form. However, I cant put this type of combo box on a datasheet subform, so I need to place it on my main form. Question: How do I find a record on...

That's exactly what I needed... Thank you.

I am wanting to store an expression as a string value in a bound textbox (example: "=1/(4*8)"), and then use it as a control source in another textbox. Would this have to be done as a VBA function?

You know, I thought it did have that structure, but I am using Access 2007, and the Northwind.accdb does not have the same structure in that regard. ...so I downloaded the mdb version and found my solution. Thanks for the redirect!