Form Issue - List not getting populated

[Mavericks334]

Hi,

I have a form that has 3 lists.

1. Major Activity
2.Sub Activity
3 Frequency

I have created the form in such a way that the moment i select a Major activity, the related sub activities show up and when i select the sub-activity the frequencies show up.

The problem is there a multiple frequencies
1.Daily
2.Weekly
3.Monthly

And when i select any subactivity, list only shows Daily, it does not show the rest of the subactivities.

I have used bound to column 0";1 and SELECT Frequency.SID, Frequency.Frequency FROM Frequency WHERE (((Frequency.SID)=Sub_Activity)) ORDER BY Frequency.Frequency;

this code to get the information accordingly, however it does not work.

Could someone tell me, where i am going wrong.

Regards,
Renato.

[jackd]

Please show your tables and relationships. What exactly do you want the form to do?

[Mavericks334]

There are 4 Tables, Activities, Tracking, Major activities, Sub activities and Frequecy. For each major activity there is a corresponding sub activity which is linked by using the Major activity id#, similarly, for every sub activity, there is a frequecy which is linked using the sub activity id#.

It helps me tracking the time spent by each person on the activities that they work on a daily basis

[jackd]

You say you have 4 tables, but you mention Person and Work - don't they have some Table(s)?
How does the Activities table relate to Tracking?
What fields, keys are in each of your Tables?
How are Activities differentiated from Major Activities and or Sub Activities?

Are these statements correct?
A MajorActivity could have 1 or more SubActivity
A SubActivity has 1 and only 1 Frequency

You'll have to tell us about Tracking and Activity and Person.

You may get some ideas from this data model
Timesheets Data Model

[Mavericks334]

Are these statements correct?
A MajorActivity could have 1 or more SubActivity

Yes, Below Example for the above question:

Major_Activities	Sub_Activity	Frequency
Coupon	Collateral Interest	Daily
Coupon	Reset	Daily
Index Linked Bonds	Index Linked Bonds	Daily
Margin Calls	Prepare and Send out all Margin Calls	Daily
Margin Calls	Process Margin Calls	Daily
Reporting	Report A	Daily
Reporting	Report B	Weekly
Reporting	Report C	Monthly

[jackd]

Thanks.
What about

How does the Activities table relate to Tracking?
What fields, keys are in each of your Tables?
How are Activities differentiated from Major Activities and or Sub Activities?

and

You'll have to tell us about Tracking and Activity and Person.

You may get some ideas from this data model

(any feedback)

[Mavericks334]

The Activities Table, tracks all the information that is enetered in the form, Which includes Major activity, Sub activity, Frequency, Start time, stop time and Analyst name.

Sub activity is linked to Major acitivty by MID Field which is Primary key in Major Acitivity Table and Foreign Key in Sub ACtivity Table. Similarly Frequency is Linked to Sub activity by SID field whick is the primay key in SubACtivity table and foreign key in Frequency table..

Major ACtivity is Like a function and Sub activity is divisions under that function.

[jackd]

Function has a different meaning in Access and Programming.

Can you post a picture (jpg) of your tables and relationships to a free site and pass us the link?

Look at 4shared.com - free file sharing and storage It is a free site. There are others.