Neil Scrivener Posted March 29, 2016 Share Posted March 29, 2016 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 More sharing options...
Rick Whitelaw Posted March 30, 2016 Share Posted March 30, 2016 (edited) On what field and is your value list based? I mean the value list used to select the company. Edited March 30, 2016 by Rick Whitelaw Link to comment Share on other sites More sharing options...
bruceR Posted March 30, 2016 Share Posted March 30, 2016 (edited) 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. Edited March 30, 2016 by BruceR Link to comment Share on other sites More sharing options...
Neil Scrivener Posted March 30, 2016 Author Share Posted March 30, 2016 Hi, It's under the second row - where it says Relationships? I've duplicated the Table Relationships so that I use the 'pools' section to copy from, and then use the copied version to create the relationship. Sorry Rick - not sure I understand the question? Link to comment Share on other sites More sharing options...
bruceR Posted March 30, 2016 Share Posted March 30, 2016 Well, that doesn't work now does it. That's the point. Yes, I saw those. They are completely useless. Link to comment Share on other sites More sharing options...
Neil Scrivener Posted March 30, 2016 Author Share Posted March 30, 2016 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 More sharing options...
rwoods Posted March 30, 2016 Share Posted March 30, 2016 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 More sharing options...
bruceR Posted March 30, 2016 Share Posted March 30, 2016 "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 More sharing options...
Recommended Posts
This topic is 2949 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 accountSign in
Already have an account? Sign in here.
Sign In Now