Access "Web Database" Cascading DropBoxes..... is dead

[Shido151]

Hey guys



trying my hand at designing a "Web" database in access 2010 and not having much luck, or fun.

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 in the drop down boxes, example:

Adobe PhotoShop CS6
Adobe PhotoShop CS5.5
Adobe Illustrator CS5.5
Microsoft Project 2010
Microsoft Visio 2010
Microsoft Visio 2007



That's my first challenge

Next What I would like to do is create a form that has three cascading drop down boxes based off of the three aforementioned fields (and other fields as well but I can handle those), which will then fill in another table that will keep a record of who when where and what. So when the form is filled out properly my table will read like::

Name Location Date Developer Software Version
John Smith; Marketing; 1-29-2013; Adobe; PhotoShop; CS6;




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- the cascading portion was complicated enough in regular Access, but now that I've switched over to the web format, I feel like I'm in a straight jacket.

3- if there is any more information I can give or word this better please let me know. At this point any comments are welcome.

[June7]

RowSource for combobox:
SELECT DISTINCT Developer FROM table;
or
SELECT Developer FROM table GROUP BY Developer;