I am a beginner to Access. Please bear with me.
I have one table called “tblElbow” with information about pipe elbows. Within this table, there are various sizes, degrees, materials and dimensions for the elbows. I am looking for a simple solution like maybe a form with some combo boxes that the user can choose from to reach one unique record in the table that will provide all the information about that record. Can anyone provide me with a fairly easy solution to do this? If this is not enough info, please ask for more.
How do I make the values unique in the combo box? For example, there are many elbows with the same size. I want to be able to select one size and have the form filter for that size. Then I want to create another combo bos to filter by the next criteria and so forth, until I reach 1 record.