mrpez1 Posted April 23, 2003 Share Posted April 23, 2003 I'm creating a database (projects.fp5) that keeps track of my firm's projects. Each project has 16 different vendors taken from a master vendors list (vendors.fp5). I have 16 different layouts in projects.fp5 (one for each vendor) with standard name/address/phone/notes fields. I want each of the vendor layouts in projects.fp5 to suck the address/phone/notes out of vendors.fp5 using the company name as the match field. I have set this up using related feilds from vendors.fp5 for each of the 16 vendors. It would seem that this would work fine if each project only had one vendor. I keep running into the problem that when one vendor is changed it changes all 16 of the other vendors' contact fields. I have tried an intermediary file for each vendor that would suck the info from vendors.fp5 but apparently fmp6 won't relate data from a related field. Is a lookup the way to do this? I'm hoping I can use related feilds to keep the address data in a seperate file. Is there any other way to do it so that if a vendor's data in one record is changed it will update that vendor's data in any other record that has that vendor as one of the 16? A lookup won't do that, will it? Thanks in advance for any help... Link to comment Share on other sites More sharing options...
Ugo DI LUCA Posted April 23, 2003 Share Posted April 23, 2003 Hi, I have 16 different layouts in projects.fp5 (one for each vendor) with standard name/address/phone/notes fields. I want each of the vendor layouts in projects.fp5 to suck the address/phone/notes out of vendors.fp5 using the company name as the match field. Working with different layouts won't help as each layout is part of a unique record. Why would you like these 16 layouts for ? Link to comment Share on other sites More sharing options...
mrpez1 Posted April 23, 2003 Author Share Posted April 23, 2003 Each project (record) has 16 different vendors....general contractor, sub contractor, master planner, irrigation designer, etc... I want each record to have 16 vendors from the vendors database (of 500+ vendors). This works fine if it was just one vendor/project, but I need 16. I could do a different vendor database for each vendor type (i.e. general contractor) but I often have more than one subcontractor (subcontractor 1, subcontractor 2). Additionally, a subcontractor in one project might be a general contractor in another. So I find myself with the same problem...One record (in projects.fp5) needs more than one record from the a related database (vendors.fp5 or subcontractors.fp5). Link to comment Share on other sites More sharing options...
Ugo DI LUCA Posted April 23, 2003 Share Posted April 23, 2003 Hi, You would need to have a Join file PersonToProject where all functions, Project_Id and contact_Id are filled. No matter if a contact could be involved in different projects or if his functions could change from one project to another. The lookup would be based on the key field (subcontractor 1, subcontractor 2,...). Let me know if it's too vague.... Link to comment Share on other sites More sharing options...
Ugo DI LUCA Posted April 24, 2003 Share Posted April 24, 2003 Hi, Forgot to mention that all these persons would come from a Unique file. No need to split this file in separate files (that would lead with duplicates). You may also like to have all these 16 persons listed in a portal in the Project file. Clicking in a row would lead to the sub-contractor layout,.... where you'll have : sub-contractor_Id sub-contractor adress phone,.... that would be auto-filled by a lookup (or related field) using relationship Project :sub-contractor_Id::Vendor:Vendor_Id Link to comment Share on other sites More sharing options...
mrpez1 Posted April 24, 2003 Author Share Posted April 24, 2003 Alright....Let me simplify this so I can get my brain around the concept. I get that I need a join file, but the process still confuses me. Lets say I have Project.fp5, Project_to_Contact.fp5 and Contact.fp5. Project.fp5 has 4 fields: Project name, Contact 1 Name, Contact 1 Email, Contact 2 Name, Contact 2 Email. Contact.fp5 has Contact Name and Contact email. How do I set up Project_to_contact.fp5 so that I can enter two contacts into a record in Projects.fp5 and filemaker will go to contacts.fp5, see if they are there as records, if they are, copy the email address of each of the two contacts back to projects.fp5? If they are not there, the records should be created. In the end, I'd like if one record's contacts are updated, any other records with the same contacts would also be updated. I'm new to this, so I thought this simplest scenario might help me get a handle on what you're telling me. Thanks for the help! Link to comment Share on other sites More sharing options...
Ugo DI LUCA Posted April 24, 2003 Share Posted April 24, 2003 Hi, As you're surely beginning with relationship, just look at the simple exemple attached here to see how relationship and lookup works. There is no Join File here as a start. You will notice that was missing in your files was the Contact_Id. Create a new Project and just paste some contacts Id's into the manager and secreary fields to see how it works. Then, make a search on this forum for some other attachment that have been posted, in relation to Project Management. Just make a search for Project and purge those threads that aren't related to your problem. There are at least 10 posts I've seen by memory on the subject. Link to comment Share on other sites More sharing options...
mrpez1 Posted April 24, 2003 Author Share Posted April 24, 2003 Uhh...I think you forgot the attachment. Link to comment Share on other sites More sharing options...
Ugo DI LUCA Posted April 24, 2003 Share Posted April 24, 2003 Woops Link to comment Share on other sites More sharing options...
Ugo DI LUCA Posted April 24, 2003 Share Posted April 24, 2003 Woops .... Well no, there is a bug here today (seems like) for attachment, as I cannot attach it. Give your mail adress on Private if you wish and I'll mail it to you Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7862 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