Visual CE

You should be able to search the StoreNbr based on RackID and then based on Modules.
Display only those that have both a RackID and Module for that StoreNbr.
All forms must have at least a StoreNbr field.

Hope this helps

Bob

Client/Server Professional
PocketPC Professional
www.technobrains.com
Your Neighborhood PDA Cafe

Thanks Bob.
I am not sure if I get my point across very well. What I need to do is if the user clicks on the form for RackID's, limit all the RackID records only to those associated with StoreNbr. That works fine. Then if they click from the RackID form to the Modules form, I need to limit the records to only the modules for the RackID and the StoreNbr. All just with display forms. Is there a way to limit(filter) form records based on two or multiply criteria?

Thanks again.
Keith

quote:Originally posted by Bob_Katayama

You should be able to search the StoreNbr based on RackID and then based on Modules.
Display only those that have both a RackID and Module for that StoreNbr.
All forms must have at least a StoreNbr field.

Hope this helps

Bob

Client/Server Professional
PocketPC Professional
www.technobrains.com
Your Neighborhood PDA Cafe

I don't have Visual CE loaded anymore therefore forgive me if I do not explain this axactly as required.

What you would do is create the final output based on what you need to have done instead of basing it one how you expect the users to click. Therefore as long as you set the jump and carry over the necessary common factor you should be OK. To me the common factor
seems like StoreNbr.

Therefore on your destination form, add some lookup controls that retrieve values from the table you just jumped from. Set the key of the lookup to be the key you used to jump to this form. In this case StoreNbr.

This would apply to each form you jump to. Therefore you would do this with the RCData form and then the Module form.

Then you should only see the StoreData/RCData/Module -RackID for that storeNbr only.

Hope this makes sense and helps.
If there is a will, there is away. [:D]

Bob

Client/Server Professional
PocketPC Professional
www.technobrains.com
Your Neighborhood PDA Cafe

Here is another flowchart based on the above scenerio.

Jump from StoreData to RCData using StoreNbr.
Jump from RCData to Mobule using StoreNbr then add some lookup controls that retrieve values from the table you just jumped from. In your case the RackID. Set the key of the lookup to be the key you used to jump to this form. In this case StoreNbr. Then you should see the RackID listed for that StoreNbr.

Is this explanation better?

Bob

Client/Server Professional
PocketPC Professional
www.technobrains.com
Your Neighborhood PDA Cafe

Hi Archer:

Was my suggestion understandable?

Bob

Client/Server Professional
PocketPC Professional
www.technobrains.com
Your Neighborhood PDA Cafe

Hi Archer:

Was my suggestion understandable?

Bob

Client/Server Professional
PocketPC Professional
www.technobrains.com
Your Neighborhood PDA Cafe