Jump to content

Display fields in portal from related fields in another portal


joser007
 Share

This topic is 5659 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Hello everyone,

It is great to see such resources on the web for Filemaker.

As to my issue...I am trying to develope a coding system to cross-code dental and medical codes.

I have 3 databases and 2 join files

AMA

MEDAMA (join - reconciles relationship between AMA and MED Codes)

MED

ICD9Med (join - reconciles relationship between ICD9 and Med Codes)

ICD

In the ADA table I have a layout with a portal to assign medCodes. There could be multiple medCodes per ADA code, which are stored in the MEDADA db.

I now would like to display on the ADA layout (portal) all of the icd9Codes pertaining to the related medCodes.

I've tried creating a calculation field in the ADA db that counts the occurances of related medCodes in MEDADA. This allows me to display the icd9Codes for the first medCode but not the rest. This would work if all I did was assign one medCode, but that is not the case.

If anybody can shed some light, I would be extremely greatful.

Link to comment
Share on other sites

Hi, you might want to consider upgrading to V8 since this would be much easier : showing related records from more than 1 table away is a snap (well sometimes not...). To my knowledge something like this is not possible in pre-V7. But I may well be proven wrong by some of the experts around.

I assume you have made a relationship from ADAMED to ICD9MED, based on MedID. Problem is that from ADA, you can only reference the first related record (from ADAMED) as a calculation field, there is no way (that I know of) to calculate a key with all the related ID's.

In the attached files (look at ADA), I've done it using a multi-line key which is set by a script. Hope this suits your needs.

Regards,

Peter

ADA.zip

Link to comment
Share on other sites

This topic is 5659 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.