Morning,
Here's what I am trying to do, I want to make a database that will compare a list input and work out the best way to fill the requirements. For example, I have 3 leads:
Lead 1 has A, B and 2 C type connections
Lead 2 has A, D and 3 E type connections
Lead 3 has 2 B, D and E type connections
I want to be able to enter what I need, for example B and E, and it pull the best fit record (Lead 3 in this case). Also, I would like it to pull multiple leads if there isnt a single one that fits the criteria, e.g. I need C and D, I need to use lead 1 and 2.
Is this possible, and if so how?
I have dabbled in Access for data storage and forms before, but nothing like this as of yet
Any help is appreciated
Kind regards
James