I have 3 databases one named Data Entry, Clerking and Models. I have a field named Model_ID in Data Entry. I have a field in models named make_model_key which is a combination of two individual fields in models which are make and model. In the Data Entry database I have the field model_id setup as a value list and displaying the value make_model_key from models. I then add the related fields make and model from models to the database Data Entry. The result is when I select the Model_ID, the make and model fields are automatically populated. My problem is that in the third database named Clerking I want the same information showing up in the make and model fields of Data Entry to also show up in Clerking. I am extremely frustrated by this as I have been working on this for a while and cannot figure it out.

Robbydobbs

You forgot do give us some clue. What are actually the fields you have in Clerking that would allow a relationship ?

May be model_ID ? If so, use a lookup from Dataentry where Clerking:Model_ID::Dataentry:Model_ID is the relationship.

The following is the setup of the three files: The relationship between Data Entry and Models is model_ID=::Model_ID. The three fields I use in Data Entry are Model_ID, ::Make and ::Model, where Model_ID in Data Entry is a defined field and ::make and ::model are related fields from models. The relationship between Clerking and Data Entry is Lot_ID=::Lot. The Lot number in Data Entry is a unique number that does not get repeated. When I relate Data Entry and Clerking I can receive the ::Model_ID from Data Entry as a related field, but ::make and ::model does not appear as they are orginally from Models. These two fields are the ones I want to show up in Clerking. I can not pull them from Models as they are not related to that particular lot number. Models is it's own database with only make, model and model_ID as fields. Thanks for any help you can give. I appreciate the help you have supplied so far.

Robbydobbs