Form Query

[GavZ]

Hi - This is giving me a real headache so i hope i explain it right!

I have one table (t_delay) and two form which work off that table - one for updating (f_delay) and one as read only (f_delaymenu).

I have attached the database and put some dummy data in there. As you can see the read only form has 5 fields to view - trouble is i want it so that it filters the CSP field down so there is only one record per CSP then the second field which is service has a combobox which has the services in relating to that CSP and when you change the service the Date Delay field and the Delay differnce field changes

I really hope this makes sense - sorry to sound stupid but i am quite new to Access!


Thanks in advance!

 

[Luddite Lad]

The first thing you need to do before you start looking at your forms is to tidy up the structure of your tables and the data they contain.

1) You have a number of ambiguous filed names. The field called ID appears in all three of your tables, in two of those it appears to be a primary key, in the third it appears to refer to on of the Primary keys (I presume the one in Table t-csp but I'm not really sure)

2) In your tables t_delay and t_csp you are storing a field CSP this need only be stored in one table (t_csp I'd guess) and then the other need only store the ID that corresponds to the relevant CSP.

3) there is no need to store data that can be derived from a calculation using a number of filed in that table (txtdifferance in table t_delay) there are quite a few discussions on the pitfalls of doing this throughout the forum. In short if you can derive a value from data that is already stored in your DB, then calculate it when it is required DON'T store it.

There may be other issues but that's as far as I got. Sort those out and repost your DB and I'll try and have another look at it for you.