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.