Jump to content

Relating via an empty match field


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

Recommended Posts

Hi there,

Please help if you can.

I have 3 tables, Programs, Providers and Facilities.

I want to relate each program to it's provider and facility.

I have made a complex relationship where

Programs::provider ID = Provider::provider ID

AND

Programs::facilityID = Facility::facility ID

This works fine except in cases where there is no facility so the facility ID in the Programs table is blank. FM does not read the blank field in both tables as a match so the relationship doesn't work. I'd like it in cases like this to fall back to a simple relationship based on the provder ID match fields.

Any ideas.

Thanks,

Kit

Link to comment
Share on other sites

Hi there,

Please help if you can.

I have 3 tables, Programs, Providers and Facilities.

I want to relate each program to it's provider and facility.

I have made a complex relationship where

Programs::provider ID = Provider::provider ID

AND

Programs::facilityID = Facility::facility ID

This works fine except in cases where there is no facility so the facility ID in the Programs table is blank. FM does not read the blank field in both tables as a match so the relationship doesn't work. I'd like it in cases like this to fall back to a simple relationship based on the provder ID match fields.

Any ideas.

Thanks,

Kit

Hi Kit,

Since there needs to be a match for the relationship to work, why not create a record for facility "None" and use that.

polydore

Link to comment
Share on other sites

  • Newbies

I think you should create a unique field that denotes that there is no facility applicable. Perhaps 'none' is not appropriate and a unique value would work better? In your list of facilities have you used zero as a value?

Link to comment
Share on other sites

This topic is 5693 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.