Jump to content

Unrelated Tables?


Neil Scrivener
 Share

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

Recommended Posts

Hi Guys,

So I'm having a bit of a disaster.

I've made a really basis opening Database. I've managed to get Drop Downs to connect my People to my Company/Clients. Easy!

Where I'm having the next issue is in my invoices Layout. I basically want select the company and have the program fill in the address, but it won't.

I've looked for related tabes, but it says there are none? I'm a bit confused, as I've related my ID in my Clients Table to my IDFK in my Invoices Table. I can see a relationship between the tables - but it's not working!

Can anyone help where I've gone wrong?

Thanks!

Database.fmp12

Link to comment
Share on other sites

Quote

 

Where I'm having the next issue is in my invoices Layout. I basically want select the company and have the program fill in the address, but it won't.

I can see a relationship between the tables - but it's not working!

 

You can?

I can't.

no relation.png

invoice_relation.png

Edited by BruceR
Link to comment
Share on other sites

Ahh ok. Just to be clear, they are not duplicate tables, just to give the relationships an easier way to show. 

So if I link the orginals as per your screenshot (ie Client ID to IDFK in Invoices), this will work?

Sorry to sound dense, I thought the idea was you could make table windows so that you don't have lines everywhere?

Link to comment
Share on other sites

Hi Neil

When you create extra occurrences of your tables in order to create relationships (like you have in the 'Relationships' area of your graph) then you have to base the layouts on those extra occurrences. 

If you base the layouts on the occurrences that Filemaker creates for you, which are not related to anything, then FileMaker doesn't believe them to be related to any other tables (even though you have other occurrences of that table that are related).

You have to imagine where you are on the graph (in your head!) and understand that you can only see (or use, or display) fields that you can reach by following the relationship lines.

It can be annoying, but it is just the way FileMaker works.

Link to comment
Share on other sites

"So if I link the orginals as per your screenshot (ie Client ID to IDFK in Invoices), this will work?"

What happens when you try; perhaps even before asking? 

Link to comment
Share on other sites

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