Linked Tables in Form

[cmccarroll@verizon.n]

I have a form with multiple tables that are linked by a userID [fid]. My first table is my list of teachers with the following fields: [fid],[fname],[lname]. All of my other tables have the following fields: [fid],[o1],[o2],etc. When I first open the form, I see my first teacher, but none of the data in the other linked tables. If I navigate to the next teacher, I see the linked data in the other tables. If I navigate to the next back to the first teacher I then see the linked data in the other tables

 

[Dumbfounded]

Hi,

Can't really see where you're going wrong - any chance you can post your db so we can have a look - might be something quite simple that just needs a new set of eyes on - but there again it might not

Thanks,

D.