Input data with form, need real time filtering. HELP ! :'(

[Nyomógombostelefon]

Hi there stranger!

I need help so much, because I need to do a database input for work, and I started from 0 database knowledge, now in 1,5 weeks I finished a little bit complicated database, but i need to do inputs for it and i can not find answer for what I want to do. I’m searching for days now, but 0 success. So any kind of help or tip would be appreciated so much <3.

So, my problem is, that i built a database, entered and loaded up with data. (Like names, customers, projects, etc.)
I got everything in it’s own table, with it’s own ID, etc, so normalization is kinda OK i guess.
The thing I want to do, is that I created a table called “ENTRIES”, which would contain the entered input by co-workers.
In this table, i got Entry.ID, Entry.Comment, Entry.DATE, and a few foreign IDs (employee,customer,location etc.).

I want to create a form, so need only to run this form and enter the inputs, we will need later at reports.
In this form, there would be an ID (autovalued), a DATE(stamp), and a COMMENT, where they need to write the reason of the entry (task is made, xy happened, sold the product etc).
AAAAND: There would be a few list, or something that would be comfy for use.

First step would be to pick a Name from a list, (who is writing the entry), second is to pick the customer (who is the customer we are talking about), 3rd: location (of the customer, romania,slovenia etc,) 4th: select a project and 5th is to select a device.
This is what i did kinda good, and it worked, but there are around 6000projects, and around 2Million devices which made it horrible.

So, the thing I want to do ( and need help for), is that when somebody pick his NAME (and the EMP.ID is saved in the input’s table EMP.ID field ofc), the next selection should be filtered only for CUSTOMERs who is paired to the NAME (or ID), and the next section should be filtered to the Customer’s projects only and so on.

I know it should be done somehow with subforms, but I can only read out existing data with that, but not enter new ones. :\

Sorry for the language errors, but i hope you get what I am trying to do :P.

At the end of filtering and inserting this info, the co-worker should write a comment and that would be the input report (for a weekly report) we need later.
Who-for what customer-at which site-on what project-with which device-what he done.

Please help guys, I’m going crazy atm.

Thank you so much, and have a nice day.

-Szabi

[Nyomógombostelefon]

I found out that I can filter what is shown in the list box by a query, and a refresh button. Now my problem is when i click on name, and refresh button, the list shows the customers connected to the name i chose, but whatever i do, it never saves the data in the field of the table. I tried almost everything, but it isn’t saving…
What could be the problem?

[Ratslinger]

It is too much to go into any details for the project you are specifically working on. It certainly appears you need filtering on progressive list boxes. That is, the selection criteria in one list box is dependent upon the choice made in another. This is probably best done with a filtering record.

Here is a post which covers much of this including many examples - click here.

If this answers your question please click on the (upper left area of answer).