Trouble getting at fields values from an alias query

[Turflayer]

Hi, I'm very new to Access, so I hope somebody may help as I've been unable to locate a similar query elsewhere on the forum...
I have created a database that is populated via a main form. Part of the form relates to an 'operatives' table that data is located through a combo box and join through common fields, and other fields relating to the operative (ie trade, mobile number etc) have been brought on to the form for user information. However, I am attempting to use the same table via another combo box to chose a different second operative. I have created a query to an alias 'operatives' table, and using the query I collect the operativeID through the new combo, to copy to a new common ID field on the main form. I am able to place the operativeID field reference in the new ID field I'm using as the second join, but the trade, mobile number etc fields still refer to the original operative.
Am I missing something, or should I be looking at a fix using VBA?

Hope this makes sense, and many thanks in advance for any assistance,

Ade.

[NeoPa]

I'm afraid that, no matter where I guess the punctuation should be, I can't get this question to make sense.

Perhaps you could rephrase more carefully and we can look at it again.

[Turflayer]

My apologies, I'll try again.

I have a main form that I wish to populate my main table with data contained in an Operatives table. I have successfully used a combo box on the main form to populate with the first operative record chosen.

I wish to be able to access further operatives from the same Operatives table within the same main table record, and propose to use a new combo and an OperativeAlias table. However the OperativesAlias table and the required fields are not available from the Add Existing Fields list when requested. I trust the required fields are available using a different route, but as this is my first attempt at creating a database in access, I'm finding it difficult!

I hope the above makes things a little clearer.

Ade

[NeoPa]

What can I say?! This is no clearer.

Without wishing to labour the point, this second example illustrates exactly why it's so difficult for me to understand you. You have not even formed your explanation into recognisable sentences.

To log my current understanding I will note what I guess you are talking about, but I will not be spending my time trying to decipher any future posts if they are as poorly formed (fair warning).

I guess you have a form based on a main table which is attempting to link to multiple records in an Operatives table. There are multiple fields in the main table which link to separate records in the Operatives table and the available Operatives are possibly filtered on some other field in the main table. Whether or not all the Operative link fields are filtered by the same value is unknown.

You are attempting to display the detailed info (from the Operatives records) on the form.

Points to consider :

1. What is the SQL source of the main form?
2. What is the SQL source and configuration of the multiple ComboBoxes?
3. Is it wise to try to link all this together on a single form rather than using distinct or sub-forms?