spiggott
-
Posts
4 -
Joined
-
Last visited
Everything posted by spiggott
-
Okay, so I'm new to Filemaker which I'm sure is painfully obvious. I created a fourth table, "summary", with the field "asset_id". But do I need to set that as a looked-up value to get the data from the other tables? Otherwise, when I create the portals on the summary page they are empty because there apparently are no related records. Sorry if I'm being obtuse, this just seems so foreign after working with MySQL previously.
-
I can't seem to get the related table set up correctly. Any pointers? FWIW, the relationships of my three existing tables is based upon the "asset_id" field in each. "Asset_id" is a unique, auto-enter serial that is created when I add an asset record. Thanks again.
-
I'll give it a try. Thanks a lot!
-
I have a database with three related tables: assets, troubles, and changes. I would like to create a "summary" layout that will show me the 10 most recent records from each of the three tables so I can see, at a glance, the most recent entries into the database. Does anyone have an idea of the best way to go about this? Thanks for any help you can offer.