BKWill Posted February 1, 2005 Share Posted February 1, 2005 Hello my name is Will, and I've been using File Maker for almost a year now. I recently upgraded from 5.5 to version 7. I love it. The new graphical interface for Relationships is great. However I'm stuck trying to decide the best way to structure a tracking DB I've been working on: Problem - 1.) I need to create a database that lets me collect Contact Information,2.) track Indivulal Items from our clients that are sent to the Contacts by displaying the date it was sent, 3.) it needs to be show multiple items and dates, 4.) It needs to show items #2 & #3 for each client. Filemaker 5 Set Up: In the old version I have the main contact information layout, and a tracking layout. The Contact name is merged into each record in the Tracking Layout to identify the tracking info with the contact. I have then created a host of fields for each client - ( Fields inclucde: CD Sent, CD Sent Date, LP Sent, LP Sent Date, Comments, ect..) The issue is that I have to add and define 16 feilds in the database every time I get a new client, a process that is long, tedious, and lacks functionality. --------------- Filmaker 7 Solution Basic Structure is the following: (4 Tables - Please See Attached Image) Contacts Tracking Tracking Items Clients My question is this: What is the best way to get to display the Tracking Information for Each Client for Each Contact, and what are the relationships I would need to create? You can see what my intial approach was, but I don't think it will work they way that I want it to. Please advise, Thanks, Will example.pdf Link to comment Share on other sites More sharing options...
This topic is 6620 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
Already have an account? Sign in here.Sign In Now