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.
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.
I'm doing this is Access web database which seems to severly limit my motions and only lets me do macro.