help?create a dataset with ability to search through a macro form?

[lizcliff]

Hi

first post (apart from introduction)

i orginally thought i should do this in excel but i think when the dataset becomes larger and i want to eventually get it on the web - i thought its access i need?

anyway:
i have created a mini dataset as an exmaple of what im trying to explain...
(sorry i dont know how to display as table)

i have in first column the objects, and columns after this are the elements needed to make the object (i have just labelled the element titles a b c etc - there will be LOTS of elements once i get the dataset created).

so if i had a red blue green cream elements - a search would bring back both lights and lamps that i am able to make.

object A B C D E F G H
lights red blue green cream
lamp red blue green cream
garage red blue green cream yellow brown purple pink
house orange white green blue red black
garden orange white green blue red
garden house orange white green blue red

is there a way of creating a search lookup to this kind of information? a form which you type the criteria in and it brings back what you can make?

and as a bonus if possible... if i was one element away from an object could I use a wildcard function to say, if you had black you could make a house?? etc


thanks you for any help you can offer me
Liz x

 

[lizcliff]

thank you
im not sure i understand
i create a table for all the objects
and create a table for all the elements

then create a table for all the object IDs and element IDS?
whats the element value?

thanks