t1/fm1 and t2/fm2 -- how coordinate?

[worldsci]

table1(t1) and form 1(fm1) have
field1 (fd1)
field2 (fd2)
field3 (fd3)

table2(t2) and form (fm2) have
fd1(same data as in t1-fd1)
fd2 (ditto)
fd3 (ditto)
fd4
fd5
fd6
fds 7-59

fd1 is a unique-identifying-code
there are 20k record in fm1
accordingly, there will be 20k in fm2

you can enter t2/fm2 by clicking a button on fm1 or by entering t2/fm2 directly
Q1: when you call up fm2, I want fd1, fd2, and fd3 to be populated with the data that is in fm1 -- how do I do this?
Q2: in fm 2, as you scroll through fd1, fd2, or fd3, I want data associated in fds 4-59 with the entity characterized by 1,2,and 3 to scroll also and change appropriately -- how do I do this?

this is a scientific, natural history database, not the usual suppliers/orders db, tho there are analogies

 

[ToeShot]

Are the more items in table 1 than what you are showing here? if not I think you might be looking at this the wrong way. You wouldn't need table 1, all the information is stored in table 2

if there are more items in table one then migh want to create a third tabler that holds fields 1, 2, 3, then use subforms to sync your data when you scroll through your records.

Dave
ToeShot@Hotmail.com
Today Is Tomorrows Yesterday. So Why Wait

 

[worldsci]

there are more items in t1 than I'd shown

why is a third table needed?

would it be possible/desirable to just make fm1 a subform in fm2, rather than anything more complicated?