LaRetta Posted August 10, 2006 Share Posted August 10, 2006 In define database and relationships - your relationship graph, double-click the = between them and it will open. Re-select CompanyID on both sides and click CHANGE. You're almost there. :wink2: Link to comment Share on other sites More sharing options...
LLX Posted August 10, 2006 Author Share Posted August 10, 2006 all that is there is cuniquen name = cunique name, i shoud change toa to companyid both sides? Link to comment Share on other sites More sharing options...
LaRetta Posted August 11, 2006 Share Posted August 11, 2006 Correct. We're crossing a creek from using data which may change (to hold the relationship together) to a uniqueID which will NEVER change. Link to comment Share on other sites More sharing options...
LLX Posted August 11, 2006 Author Share Posted August 11, 2006 ok did that, and created the sent id, im going to change the issues sent out list to reference as many of records as i can then do the portal. i shoud make the protal in the records list or issues sent list? Link to comment Share on other sites More sharing options...
LaRetta Posted August 11, 2006 Share Posted August 11, 2006 (edited) There are many issues for one Company. This is a one-to-many (or 1:n) and you view portals from the ONE side (Companies). So on a Companies layout, create a portal of your Issues Sent. One more thing. Both uniqueIDs (CompanyID and SentID) should be auto-enter but ALSO 'prohibit modification' should be checked. And never put these IDs on a layout (or in portal) where User can change them. If you display them anywhere, be sure to select the field, right-click and change behavior to NOT allow entry in Browse. If you change the CompanyID in your portal, ie, change the CompanyID in your Issues Sent, then you will break the relationship and that record will disappear from the portal. Have fun. :smile2: Edited August 11, 2006 by Guest Added sentence Link to comment Share on other sites More sharing options...
LaRetta Posted August 11, 2006 Share Posted August 11, 2006 ... but ... "im going to change the issues sent out list to reference as many of records as i can" ... they should already be related now. When you set the Issues Sent CompanyID with the Companies CompanyID. They should all be related (except for the wonky 11). Link to comment Share on other sites More sharing options...
LLX Posted August 11, 2006 Author Share Posted August 11, 2006 i was refering to this "Those fields in Issues Sent (Company, First Name, Last Name, Phone and so on) are unnecessary because they can be displayed through the relationship instead." Link to comment Share on other sites More sharing options...
LaRetta Posted August 11, 2006 Share Posted August 11, 2006 Right ON. ^) Remember that you won't want to display Records::Last Name and so forth in the portal though. Users will already KNOW that information because it will appear on the main Records layout (each Company). But if you need to display from Issues, you can use Company fields directly. And you're rockin' now! Link to comment Share on other sites More sharing options...
LLX Posted August 11, 2006 Author Share Posted August 11, 2006 no the portal is just for Issue name, violune issue number, etc Link to comment Share on other sites More sharing options...
LLX Posted August 11, 2006 Author Share Posted August 11, 2006 Night LaRatta, tiem to leave the office ill work o nthe portal tomarro and give a report of how it goes Link to comment Share on other sites More sharing options...
LaRetta Posted August 11, 2006 Share Posted August 11, 2006 Have a good evening. :wink2: Link to comment Share on other sites More sharing options...
LLX Posted August 11, 2006 Author Share Posted August 11, 2006 well im back and im trying to add the portal, if i add it in issues sent list it does it per record and if i do it in record list it doesnt load anything. Am i missing something about portals? Link to comment Share on other sites More sharing options...
LLX Posted August 11, 2006 Author Share Posted August 11, 2006 correction: It only shows a hand full of records, out of 400+ Link to comment Share on other sites More sharing options...
LLX Posted August 11, 2006 Author Share Posted August 11, 2006 on another note, since some of the records i had already manually combined milti line is their a quick way i can split them up? They all have the same format with a caridge return seperating them. or do i have to do it manually Link to comment Share on other sites More sharing options...
LaRetta Posted August 11, 2006 Share Posted August 11, 2006 (edited) "correction: It only shows a hand full of records, out of 400+ " On each Records layout (Company), it will only show those records which relate, ie, have the same CompanyID. How did you combine them into multiline? Did you create something like this? IssueName (space) Issue (space) Sent On (space) ... and so forth, then carriage return then the same thing (another record) on the second line? Addition: Because you will need to not only split them by record, but split them by FIELD. And if any field was blank ... well ... Edited August 11, 2006 by Guest Link to comment Share on other sites More sharing options...
LLX Posted August 11, 2006 Author Share Posted August 11, 2006 Issue name is a field which as a caridge return so it be like June 2006 June 2006 of the ones i multi lined i made sure all the portal field were filled as for the records their about 500 entries in my issues sent out and about 400 in records, but when i use the portal not Every record shows its assosiated issue sent out. i think some data must have been lost i fear ill have to manually enter the mising data Link to comment Share on other sites More sharing options...
LaRetta Posted August 11, 2006 Share Posted August 11, 2006 I suggest you instead grab your backup. It will be easier than attempting to split some of the entries and re-entering others. You now know what to do - do it again on the raw data prior to your conversion attempt. Link to comment Share on other sites More sharing options...
LLX Posted August 11, 2006 Author Share Posted August 11, 2006 i did use my raw, liek a nubie i mad a back up of my company file but i edited the Raw data of the sent out Link to comment Share on other sites More sharing options...
LLX Posted August 12, 2006 Author Share Posted August 12, 2006 on a side note some shoud "Stickie" this thread its a great primer for relationships and potals Link to comment Share on other sites More sharing options...
LaRetta Posted August 12, 2006 Share Posted August 12, 2006 (edited) Hmmm, well it sounds like you'll have some data to clean up. Been there ... done it. If not all Issues Sent are being shown on their respective Records layout, it may just mean that it didn't set the CompanyID in one of the two tables. Did you check to be sure it serialized them all properly? Because if your relationship is from Records::CompanyID = Issues Sent::CompanyID then it will work. If you wish to clean up those multilines, we can do that ... but I'm still unclear on what the data looks like. If you multiline two records, there are several fields involved. But that should probably be another thread, something called, "Un-multilining multiple fields." We can do it but we must have specific field names and know the delimiter you used. Or did you just open a field, add a carriage return, and enter the next field's single entry all the way through the fields? If so, we can script a reversal for you. NOTE: If you added the second record's data to each field, what did you do if the field was empty on the first record but had something on the second? Did you put a carriage return then add the entry? LaRetta Edited August 12, 2006 by Guest Added Note Link to comment Share on other sites More sharing options...
LLX Posted August 14, 2006 Author Share Posted August 14, 2006 (edited) no field should be empty (unless i hadent finished entering the data manually in wich case its moot the true copy record hasnt been deleted) any fields that were empty weir either place holder records or incomplete copies. Any time a new records was multi lined they has issue name, volume, number, sent number, office from, and sent date it was just a caridge return concatonation Edited August 14, 2006 by Guest Link to comment Share on other sites More sharing options...
LLX Posted August 17, 2006 Author Share Posted August 17, 2006 mad a thread for the unmulti http://fmforums.com/forum/showtopic.php?tid/179556/ Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6455 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