MnR Posted January 26, 2005 Share Posted January 26, 2005 is there a way to create a table which is linked to other tables but just shows the information from them? I have not found a way yet in FileMaker pro and i am just wondering if it is possiable. Link to comment Share on other sites More sharing options...
transpower Posted January 26, 2005 Share Posted January 26, 2005 You can place fields from other tables directly on the layout of your main table (provided, of course, that the tables are properly linked). Link to comment Share on other sites More sharing options...
Reed Posted January 26, 2005 Share Posted January 26, 2005 Are you referring to having a separate file which only contains the interface, but not any of the data? If that's what you mean, do a search for "Separation Model" Using file references, you can have a file which has no data, but simply refers to data in another file. Link to comment Share on other sites More sharing options...
MnR Posted January 26, 2005 Author Share Posted January 26, 2005 No what i mean is a table which displays the data from the other tables. And would not have to be inputed i want to basically create a table of information from information in other tables. When i do the linking, when i look at the table, it contains no data (which should be retrieved from other tables) and says i need to insert a record. maybe i need to change the = or something? Link to comment Share on other sites More sharing options...
Reed Posted January 26, 2005 Share Posted January 26, 2005 If there are no records in your "display table" then you can't have data in any of the fields that are used in the relationship to the other table. Unless the fields in your dislplay table are global fields.... Try changing the field options->storage tab to global storage. Link to comment Share on other sites More sharing options...
MnR Posted January 26, 2005 Author Share Posted January 26, 2005 what are global storage fields? and yes there is data in the tables which i am trying to link too! Link to comment Share on other sites More sharing options...
MnR Posted January 26, 2005 Author Share Posted January 26, 2005 btw just tried global fields and it wiped all the data out of a test field, but even worse it doesn't allow different values, which is kinda useless! Link to comment Share on other sites More sharing options...
Reed Posted January 26, 2005 Share Posted January 26, 2005 That's what a global field is supposed to do... it carries the same value for all records. I use a layout with only global fields in one of my solutions for the purposes of data entry. The data in the global fields is used in a script which creates/edits records in a related table. The global layout is tied to a table which has no data. Is there data in both of the tables in your relationship? Maybe you could post the file so it would be easier to see what you're doing. Link to comment Share on other sites More sharing options...
Reed Posted January 26, 2005 Share Posted January 26, 2005 Another use for globals is as variables in scripts. (loop counters, etc.) You don't need them as much in v7 as you did before since v7 introduced script parameters. Link to comment Share on other sites More sharing options...
MnR Posted January 26, 2005 Author Share Posted January 26, 2005 its just 1 pesky field which is annoying me, basically to solve it i need a way to insert it when the user selects an ID of turkey so that the weight follows the ID into the new table. Posted in the scripts section to see if there is a script solution. Link to comment Share on other sites More sharing options...
Reed Posted January 26, 2005 Share Posted January 26, 2005 I've posted a response to your query in the scriptmaker forum, and attached a file. See if that file does what you're thinking. Link to comment Share on other sites More sharing options...
MnR Posted January 27, 2005 Author Share Posted January 27, 2005 yes it does, thanks again! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7019 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