synchronizing main/sub forms

  • Thread starter Thread starter andrew
  • Start date Start date
A

andrew

Hello,
I'm trying to get my main/sub forms to synchronize, but it
doesen't seem to be working.

I have Table A, which holds information about certain
bones.

I have table B, which holds (thoretically) infinite amount
of data about the bone. In particular, the second table
is in the form (x, y, L), where x and y are coordinates in
a bone section, and L is a characteristic of that region.

So on my form, I have a pull down menu that allows a user
to select a bone, and a sub form where you enter new
coordinate data. (Note (x,y) is the primary key.)


Problem is, when I select a second bone from the pull down
menu, it doesen't update the list. And if I select it
anyway and try to put in the data, it automatically inputs
data to the first bone.


Please note that I have a declared a relationship between
the tables already, which I will illustrate:

Table 1 Table 2
Bone ID Code........[inf].Bone ID Code
Agency X
Y
L
 
It sounds like you're using a single query to feed both
TableA and TableB. I would suggest creating forms where
the data sources are the individual tables then link the
form and subform using BoneIDCode.
 
Back
Top