X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Match On Multiple Criteria, Access 2013    
post Mar 28 2020, 03:00 AM

Posts: 2
Joined: 28-March 20

Hi there,

I'm trying to map an assembly to a part number so multiple criteria to one field.

I have an assembly, which is of a certain length, but also will have multiple add ons. What is the best way to map a length, assembly, and say two or three add ons that might be different combinations to a part number. The add ons are related to a generic ID in a one to many relationship.

Gen.id add on
01 addon4
01 addon5
02 addon4
03 addon2
03 addon5
04 addon4
04 addon5

So then if I want the part number to get me an assembly with addon4 and addon5 which is against gen.id01 and 04 how to do this?
I also want to concatenate the multiple fields to fill in the description of the part number.
Go to the top of the page
post Mar 28 2020, 07:21 AM

Posts: 2,099
Joined: 10-February 08
From: Ottawa, Ont, Canada; West Palm Beach, FL

I think readers will need a little more context in order to provide focused responses.
However, I suggest you read through this thread to get some ideas re Parts and Assemblies.

Good luck with your project!
Go to the top of the page
post Mar 28 2020, 07:32 AM

UtterAccess VIP
Posts: 12,205
Joined: 10-February 04
From: South Charleston, WV


Robert Crouser
Go to the top of the page
post Mar 28 2020, 05:48 PM

Posts: 2
Joined: 28-March 20

Thank you I will try again.

tbl.map.assy - generic.id, length, assy.id, addon.id(1 to many)
tbl.addon - addon.id, addon.partnumber;

I'm thinking to match the details for each assembly at the top to have the partnumbers for eachcombo.
tbl.parts - part_number, all add ons, length, assy.id.

There are multiple generic.id that may have the same combinations.

My issue is where there are multiple values for addon against a generic id, how do I match these to a part number for the length, assembly and all of the combinations of accessories? All the changes to items need to be tracked as well so lengths etc are stored in tables.
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    30th May 2020 - 10:25 AM