Thanks so much for your help, if you could have a look at the following and try and point my in the right direction I would be very grateful. I'm learning alot on this forum.
I see what your saying, by me creating seperate tables I won't need to repeat words over and over again which is going to reduce the size of my database.
I have downloaded an example of cascading combo boxes that look at a table that has three fields in it. Each combo box will rely on the value of the previous combo box. I'm able to produce two combo boxes that are cascading but I can't seem to get the third to work.
I hope this makes sense
I have set up a relationship between two table and have enforced the referencial integrity. How can I create combo box's for each table and have the user select one record in a table and then only show the related records in the other combo box.
I hope this makes sense