And I just realized my work around mentioned above doesn't work. So here's my situation;
I've got a Table of software, it has three main fields "Developer" "Software" and "Version"
The developer and Software have several repeats I would like not to appear, example:
Adobe PhotoShop CS6
Adobe PhotoShop CS5.5
Microsoft Project 2010
Microsoft Visio 2010
Microsoft Visio 2007
So what I would like to do is create a form that has three cascading drop down boxes based off of the three aforementioned fields, which will then fill in another table that will keep a record of who when where and what.
But right now I'm focusing on the cascading part.
1

I can't get it to not repeat, ie. when you click on the drop down menu I'd like Adobe and Microsoft to appear once. I cannot find the "Unique Value" property to save my life right now.
2

I'm doing this is Access web database which seems to severly limit my motions and only lets me do macro.