Picklists Issues

Hi Creator team,

First of all, i am an Access and MS SQL Server used delighted to see how much easier it is to use your system. Keep it this way and I will be soon recommending most people to save their money and use your system.

I specially liked the fact that you made it very easy to create picklists and added lots of functions to that. Unfortunately you missed one so let see if you find this useful:

I am creating an online database for a friend to manage a shop stock. Therefore the first thing to do is a Table (what you call forms) with a Brand and Model (I would like here an option so no duplicate entries are allowed).

Next table is a Daily stock record. You can enter the date, serial and number of unit for a specific model. Now here comes the issue...

I have managed to easily do a script that only loads the models specifi to a brand. So when the user slelects Nokia from the first "Brand" Picklist, he only sees Nokia's models on the "Model" Picklist. But because the "Brand" picklist is linked to the first form instead of seing: "Nokia, Motorola, Samsung, etc..." it reads "Nokia, Nokia, Nokia, MOtorola, MOtorola, Motorola, Samsung, Samsung..."

Why?

Because that's the structure of the table for each model I write the brand one. But on my picklist I want the Brand column grouped, not every single item displayed.

It will be great to make this an easy to implement function as I think many users are going to want to do similar things. If not, do you know how to code this? The idea I had is to run a filter and then show that as options but I don't know if that is possible.

Hope you can help me or at least find this helpful. I will keep posting as I develop my application since it is always nice to help those building such fantastic apps!

Best regards,

Yonathan
ysabbah