Search results

Sorry - inadequate info from my end causing confusion 🙄

Thanks Pat, very clear :) but in this instance the type is usually some sort of product description (beef, pork, pies, salads) and the sub type the preparation description - which can be applied to many different product types (although occasionally reversed eg cooked meats as type with beef...

Thanks Doc Man, but there are (so far) 39 Types and 88 SubTypes and 129 combinations so...

Sorry for delayed response - had to go fit shelves for son's new flat... On the circular relationship in second diagram - don't truly understand - but you're right, it doesn't work. On the number of tables needed I've now managed to convince myself (probably wrongly :rolleyes:) that I do need...

Wasn't getting anywhere with it so copped out and used a single form with a subform below showing the whole order - still have to test n tweak but it does seem to be reliably functioning - thank goodness!!! Many thanks for all your input Pat :) Lx

Thanks Pat, I'd figured out the concatenation thing to get the type & sub types to show together but am lost in a morass of failed attempts on the dropdowns - I'll have a look at file you sent - Thank you! Any chance you could have a look at my relationships to see if I've done something stupid...

Thanks Pat - black magic :-) But I think my problems are more fundamental Re your earlier answer I started without the junction table but ended up with all the same errors - this is just the last of many ineffecual attempts to make it work... failing a solution I think I'll finally cave in and...

You were right :))) - I was just too fraught to see - Sorry & thank You! But... 1. When I try to create a new record in the subform the unbound combo box selection updates the previous record - is there a setting/macro that can make selection by each record? Assuming not, I bound the combo box...

Was reference like that in the products field I want to filter - I used the builder so miss spelling wasn't/isn't the issue: [Forms]![Order Details Subform Copy]![TypesAllID] I'll have a re-try with Sub types linked to types linked to the products as suggested by Pat but fairly sure I've done...

Pretty sure that's where I started - but hit the same problem when it came to the form - agree my naming is crap! (will work on it) Do you see anything that may be causing this precise problem - the rest of the database is functioning fine...

Dropdown works in subform and can be selected but can't fully test as the main form is needed to enter the order ID

Thanks Pat but did play with that - previous post gives more detail - I'm now able to see the things I want to select - just can't select them!

Have changed it again (ad nauseam :-/) still doesn't make bacon ARRRGH! Initially I wanted three dropdowns 1. Type 2. Sub Type and 3. Product - couldn't get it to work. So have tried various ways of concatenating type and sub type the last of which is below. I have a feeling this...

Whoops...

I've used SELECT DISTINCT

Can't seem to find anywhere it needs updated... could it be a problem with the underlying relationships - they are a bit tortuous :-/

Hi all, Question re an order input database (I set up years ago) that I'm having to make more user friendly for others. I have a form that allows selection of a customer and a delivery run with a subform to select products and enter amounts etc. To make it more user friendly I'm trying to use...