Hierarchical picklists at the table level

[mindbender]

Hi everyone,



I am trying to see if it is possible to create hierarchical picklists at the table level. Basically limit the values in column 2 based on the value chosen in column 1.

The reason I am trying to do it at the table level is I am using Connexa XS which is an excel add in that allows Excel to be the front end of an Access database, but it can only show the data in a table.

I have validation rules set up now that only allow certain values to entered into the columns but they are not constrained at this point.

Probably a pipedream but I thought I would ask the experts.

Or maybe there is another option for Excel front end to access backend I have not come across yet.

Thanks

Bret

[June7]

Not at table level because there is a little bit of code required to make cascading (dependent) 'picklists' work. I don't understand why cannot build a form with cascading comboboxes.

Why use Excel as a frontend at all?

[mindbender]

They want to use Excel because it has the ability to click and drag to modify multiple records. They are using Excel now but each on their own spreadsheet. I am trying to consolidate to a common backend with as little pain to them as possible

[June7]

Multiple users cannot edit same spreadsheet at same time. Whereas multiple users can edit the same table in Access at same time.

There are programmatic methods in Access to accomplish copying data to multiple records on a form. What data needs to be replicated?

[mindbender]

With Connexa XS what happens is they open Excel and link to the table and it pulls the data into Excel for them...they make their changes and then hit Save and it updates the Access table. Basically multiple users interacting with the data from an access table through their own excel spreadhseet

[June7]

They don't do anything else with the data - reports?

I was given a db that used Excel as user interface for data entry/edit and reports. It was a nightmare. I eliminated Excel and went all-Access.

But every situation is different - if your users are happy...