Ok.. I have a form "Job Order Entry

[cppiston]

Ok.. I have a form "Job Order Entry", it is linked to a table "Job Order Entry"

Inside of the formJob Order Entry, is a Drop down Box "CamProfiles"...

I have a new text box in the form called "Gage Point".

Now, the Drop Down box call CamProfiles is linked to a Table.. tblCamProfiles...

tblCamProfiles has a field GagePoint.

On the Job Order Entry form, I want it where when someone selects the CamProfile, it will enter default data (From the tblGagePoint)into GagePoint on the form, and store that data GagePoint, in the Job Order Entry Table...

Its probably easy....

Thanks ahead of time!!!

 

[cppiston]

On the Job Order Entry form, I want it where when someone selects the CamProfile, it will enter default data (From the tblCamProfiles)into GagePoint on the form, and store that data GagePoint, in the Job Order Entry Table...

Sorry, thats the correct way....

 

[beetee]

This might be an example of a non-normalized database.

When the user selects a CamProfile, you should store a CamProfile ID value in your Job Order table.

You can then look up the GagePoint by joining the JobOrder talbe with the CamProfile table.

 

[cppiston]

I have done that, my tblCamProfile and the Job Order Entry tables have a relationship.

I am having a hard time for me to get the corresponding data from tblCamProfile / gage Point to store that data in Job Order Entry / Gagepoint... and have it show as the default data on the job Order entry form...

Thanks

 

[beetee]

OK, then you don't need to store Guagepoint in your Job Order Entry table. You can just look it up from tblCamProfile.

If you want to show the Guagepoint on the form, you can use Dlookup and a label control.

 

[cppiston]

Cool, sounds good so far.. how could I use the Dlookup and the Label Control..

Could you show me.. PLeeeaaaasssseee!!