Sub Forms?

[Nav4]

I am having trouble with sub-form pulling down related items....It worked once and I change from relating from one to another and it won't work. If I pull information form a combo box, it just sits ther. If I go from design view to form view it will work ONCE. The combo box works all of the time. I know there must be one LITTLE thing I am doing wrong, but........I can't see it, so I turn to the Pros! I use the Wizard and link two different tables with similar information. The relationships are set up.......

 

[Dreamweaver]

Maybe you need to requery the sub form after you select details from the combo.

thats if you haven't set the subform for look at the combo for it's "Link Master Fields"
To reference a control on the main form add [YouControlName] Into the "Link Master Fields" and "Link Child Fields" should be a matching Fk in the subform.

Mick

 

[Nav4]

Reply

OK, I checked. It appears to be normal.............. Any other suggestions?

 

[Nav4]

Additional Info

I've attached the info...the form, subform and data tables. The calendar won't function as I didn't include those.

 

[Mike375]

The Vehicle/Planner in the small table does not match with the master table.

In the small table

3887 Abney
3892 Meredith
9830 McCubbins

In the Master table

3887 Abney
3892 Chaffin
9830 Abney

 

[CEH]

My advice...... Start over. You have tables with duplicate fields. Do a search on normalization. Get your tables set up correctly and I'm sure you will find the rest will be much easier.

 

[Nav4]

Set Up

I sat it up to pull info from a fairly static table and to write to a "active" table "SMMVehPM" where I can pull information for reports. The difference in the information is trouble pulling ffrom the "master" table on a consecutive basis. Ifn you pull up a vehicle, it does nothing. BUT, if you pull up a different vehicle, go to design view and the back to run view, the information is correct.

The Master table is fairly static, as it will be updated on a quarterly basis, ONLY if they get other vehicles.

 

[Mike375]

Is it intended that that your ID....Vehichle....is attached to different Planners in your secondary table OR is that a mistake?

From memory the records called up on your sub form are correct, given that Vehicle-Vehicle is the basis of linking BUT the names no longer match.

Is this a case where the Vehicle can change to a different Planner? Your seconday table (if correct) suggests that is true.

Perhaps the best thing to do would be to type in a post what your desired outcome would be.

A simple query on the two tables shows the mismatch of Vehichle/Planners. But again, is that intentional?

The Master table is fairly static, as it will be updated on a quarterly basis, ONLY if they get other vehicles.

So a new Vehicle is 12345 and that is assigned to Abney and entered in the master table. But why is it that Vehichle 12345 is assigned to someone else on the secondary table.

 

[Dreamweaver]

I have to agree Mike375 after looking at it you are short a number of tables as a basic you would need 3 tables.

You have no primary keys set.

Vehicle Plans
Vehicles
VehiclesAndPlans

Then there's Who each Vehicle has been assigned to if this if a company internal system then that will relate to employees otherwise your dealing with clients

But it looks like your gonna try and tye in GL accounting in to to pot??

you really need to think about things and do some resurch on access Keys, Normalization Etc.

If you look at this site there are a number of Data Models that may be of interest

http://www.databaseanswers.org/data_models/index.htm

Marry Xmas
Mick

 

[Nav4]

Supposed to work...........

The way I intended for it to work is............

The User opens the database, there are approximately 10 vehicles per week that get a PM. The User has a list of these vehicles. She inputs the vehicle number - 12345 - the database is supposed to come back and giver her the planner, so he cab schedule the PM and the Crew leader so he can make the nappropiate time to get it it to the shop. It defaults to scheduled and complete, yeah the scheduled button isn't there, but I can add that. The date is added and the record is written to the SMMVehPM table.

I believe the difference in the two tables are input error on MY part. I was trying to get it to work. The "Master" table is the correct of what is assigned to who. The SMMVehPM table shows that the vehicle was actually scheduled and PM'd. If it doesn't make it into the shop, the user, when pukking up the record clicks on the scheduled and/or complete button and removes it from being written to the SMMVehPM table.

Thanks for yur input, I am re-thinking the realtionships and requirements, maybe I do need the three tables instead of two...............

THANKS!

Nav4