how can i display a value list from DB-A to DB-B

[solarpunk]

Hello,

I was wondering if someone can help me out here. I have two databases, one is call Student and the other Attendance. Basically i have a field in Attendance call ARC which is a check box value list of Yes or No. Now, I want to display this ARC field in the Student Database but it is not doing it. it just display a box but not the check mark. The value get check mark in the Attendance database. I am using a relationship base on the ID, StudentID.

Thank you

victor

[transpower]

I've tested your situation in 7 and it works fine: if I put the checkbox field from one table into another, related table, the checkbox X's display as they should. Can't speak to version 6, but double-check your keys.

[solarpunk]

Trans,

Thanks. i am using FM 6. i will check my keys. funny part is that i use StudentID to see if it is the right one, they are they right now.

Thanks

victor

[QuinTech]

Another thinkg to check is that you have the same values in both value lists; if the data is entered as "Yes" but your VL uses Y,N then you will not see any checks. Look at the field in non-checkbox format to see if there is in fact data there.

J

[solarpunk]

Quintech.

you are correct. when i look at the field in non-checkbox format in the student database there is no data but if i do the samething in attendance database where the check is at, it show data. i am not sure if i am doing the right relationship when it come to the VL or not. I am using Yes and No the value lists.

thanks.

victor

[QuinTech]

I'm with Transpower, then, there must be something wrong in the keys.

[solarpunk]

quintech,

it is the key but not the studentID Key. i forgot to include the other databases which have relationship to.

Basically here is the db is sett up.

Student Records

Program

Class Schedule

Attendance

the reason it is not working is because in the student records database the right classid(key) is not matching the studentid(key), it matches the right programid(key). so for each student there is mutiple classes they have taken, I have a check box which get check once they have complete all their academic requirements, this is only happen once which.

i was thinking maybe through calculations, i can get it to match the right classid(key) with the studentid(key)

you all for the help...