Expression Builder

[endri81]

Hi I am working on a patient database.
I have three tables RiskFactors,Types,Dictionary.
At RiskFactor table I have field name AbortionType,at Types table I have field Name AbortionType and at Dictionary I gave two fields like StandartType and Assisted type which has the same type id as AbortionType at Types table.
In my form I have a checkbox where I need to check the type of abortion but I dont know how to build the expression for this kind of connection.
Can u give me a query for that or any similar solution?

 

[Uncle Gizmo]

I think you need to post your db to here.

 

[Simon_MT]

I would simply change the AbortionType to a combiBox and create a Table with the types and let the user select which type.

Somehow, I don't think it would be appropriate to post your database!

Simon

 

[Uncle Gizmo]

Somehow, I don't think it would be appropriate to post your database!

Well, I wouldn’t expect anyone to post a database here with confidential information in it, however I take your point, I should have made that clear in my answer. I have received several databases with confidential data in over the years! Thank you for pointing it out.