Linking Tables Help

[Kitty]

Hi,

I started creating scripts and linking tables together but no luck. I must be doing something wrong. Can someone out there help me, pretty please.

I am trying to link the following tables by study id and visit:

BASCParent, BASCTeacher, BASCSelf, and Summary_Scores_II

If user navigates from one table to another and there is no common study id and visit, then

a pop up message will tell the user there is no related record on study id and visit. The pop up

message will ask the user if they would like to create a related record with study id and visit.

If the user clicks yes, then study id and visit will be copied into the table the user chose.

If the user clicks no, then nothing will happen.

I am also trying to link the following tables by ONLY study id:

Summary_Scores_II, IEP_Actual, IEP_PT

If there is no common study id, then the user will have same pop up message as above.

Please note, the Demographics will link to all tables by only study id.

I have also added the db as an attachment and some sample data to test. thank you so much for your help.

Account Name: [color:red]admin

password: [color:red] test

ACS.zip

Edited October 9, 2007 by Guest

[LaRetta]

UserName and Password?

[Kitty]

Hi Loretta,

I just downloaded the latest db version. I had originally posted the wrong one. If you already downloaded it to your computer, please download again so that you have the latest version.

The account Name: admin Password: test