tables w diff fields-merge

[Dan @BCBS]

One table used check boxes, the other table used yes/no.
How can merge tables into one without loosing the data.
I don't mind changing the check boxes to yes/no or visa-versa, but it looks
like this will delete the data.

HELP

 

[Lynn Trapp]

Could you please explain what you mean by the difference in "check boxes"
and "yes/no." A check box is merely a way to visually represent a boolean
(yes/no) field.

 

[Rick B]

How many places are you going to post this message? You need multiple
people working on this for you?

As posted in another group...


Unless I am mistaken, a checkbox field is a yes/no field. At the table
level, you format the field as yes/no data type. The "format" (yes/no,
true/false, on/off) does not matter. The data in thetable will still be a 0
or a -1.

Rick B