Trouble in calling or getting field records from another table

[annayanagi014]

Please help me to solve this problem. I have 2 tables. The first table is "sample1" the fields in the table are



code . Subject .
----- ---------

The second table named "Sample2" has the same fields in the first table. What i do is the field "code" in first table is related in the second table in the field "code" also. Now, if the user enters a record for example "dog" in the field "code" in the first table, it will appear in the field code in the second table as a dropdown and the same "dog".

what i want to do is if i selected dog in the second table, the "subject" field will get the record in the subject field in the first table and will be show on table 2 in subject field.

Thanks for helping

[June7]

Don't understand data structure. What is this database for? Why would you duplicate data between tables?

[annayanagi014]

Thanks sir for replying. Im planning to split forms over a network in our company. we have a message center and 8 divisions. Now, if the message center enter a subject. i want the divisions to view also the subject that the message center type.

I have my sample here:

Now i when i click the promotion listed in the Itdivision table i want the Remarks to be the same in the first table which is "Promotion is for promoting etc etc!" Thanks!
(Subject in the first table is related in the subject in the second table)

[June7]

Users should not interact with tables and queries, just forms and reports. The Remarks info should not be duplicated into the Division table. Options for displaying the related Remarks info:

1. multi-column combobox http://www.datapigtechnologies.com/f...combobox3.html

2. query that joins the two tables

3. DLookup()

[orange]

??? Step back and tell readers in plain, simple English --no Access and No jargon--
WHAT are you trying to accomplish?

[annayanagi014]

Thanks June7! You're the best man!