Arny Posted September 30, 2009 Posted September 30, 2009 This is most likely a trivial solution to most of you but I'm perplexed on how to proceed. Normally I create all of my tables in a single instance of a database and get all of my information from the relationships developed in the database. Now, I have three totally independent databases [all FMP] one of which needs to get selective information from the other two. In some respects this is a type of 'dashboard' concept . . highlighting specific information from completely independent databases. I can't seem to find any way to access this information other than through the relationship process, which requires me to import the tables. I've established the file references for these two tables, but don't really want to set up a relationship that requires me to import the 'foreign' tables. My thought is that all I'll have is a duplicate instance of the foreign table, when I'm looking to access 'live' information. Am I missing a basic tenet of FMP 8.5 or do I need to investigate another approach.
T-Square Posted September 30, 2009 Posted September 30, 2009 Amy-- You're missing a basic tenet: Establishing relationships between tables in separate files doesn't import the table--it simply creates a pointer to the remote table. The data remains in the other file and is edited/added to that remote table. HTH, David
Arny Posted September 30, 2009 Author Posted September 30, 2009 David; Thanks . . I can't breath again.
Recommended Posts
This topic is 5592 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