Jump to content

Adri Oosterwijk

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Adri Oosterwijk

  • Rank
  • Birthday 03/03/1964

Profile Information

  • Gender
  • Location
    Reeuwijk, The Netherlands
  1. Hi all, Probably this is a simple issue but I'm lost. In my database is a field called "Row" In this field there are values such as: Sl 1-1 Sl 1-2 Sl 1-3 Sl 1-3a Sl 1-4 Sl 1-5 and so on. I set a variable $$CHECKROW with a value form one table and the find is performed in another table. When I do a search in a script for $$CHECKROW ( value Sl 1-3a ) it is working great. Only one record found wich is matching the criteria. However when I perform this find for Sl 1-3 it also finds Sl 1-3a and that is not ok. In the find dialog I can set the criteria to ==$$CHECKROW but that don't work. I think FM is searching for the exact value "$$CHECKROW" and not the exact content of the variable. Is there a way to find the exact value of this variable. Thanx for your help.
  2. Understood. I will rework it. I'm sure that I'm gonna solve it using your input. Many thanks and I let you know. Reagards, adri
  3. Forgive my poor English, thats what I meant. I think. The values in the graves table are the complete Numbers or codes for the graves. A complete gravenumber is a concatenation of a section, an area, a row and a number. The Row number will be calculated (section & area & rownumber) in the rows table and the complete gravenumber (complete rownumber & gravenumber) in the graves table. Example: Section = SL Area = 1 Row = 1 Rownumber = Sl 1-1 Gravenumber = 1, 2, 3 Complete gravenumer is: Sl 1-1-1 Sl 1-1-2 Sl 1-1-3 Do we have the same in mind or didn't I understand you at all? HTH Adri
  4. Oops, I have to rework my db. Ok, as that is what it takes. When I make the choice to do it the way I did (one table for all separte pieces of data to create a gravenumber) I thought it was the right way. I was expecting some difficulties but I was sure to overcome them. Sadly, this is not the case. I'm gonna rework this part of my solution and I hope that it will work. I was aming to get a result of -> Count all positions in a row ( a row is unique for a cementary by relationship and ) and substract (is this the right term?) the number of reservations and graves taken by funerals as well to get the amount of graves available in this given row. When the user makes a reservation for a customer the solution only shows those rows when there are available graves. (available graves: Row says: 10 in total, taken by reservations: 4, taken by funerals: 3, = 3, available. The difference between GRAVEN_TELLING and AANTAL_GEBRUIKT tells me the quantity of available positions (graves) in a given row. The relationship, however, I created was not working the way I expected. Regarding your reply this will not work the way I expected. I will split up the graves table in a sections, area and rows tabel. the graves table will only show the numbers (1, 2, 3, 4 etc) for a given row and the complete gravenumber. I hope to get it solved this way. Thanks foor your help so far. Kind regards, Adri
  5. Hi Comment, Thank you for helping me out. I will try to explain. Every cementary have areas, every area have sections and avery section have rows. "Rij naam" is a fieldname and is a aggregation of a areacode, sectioncode, and row code. In the table "Rij naam" ( row name ) is a textfield filled wit the formula Section & " " & area &"-"& Row ( translated ). A position is a grave. In every row ( Rij naam ) there are one or more graves available. So the field "TELLING_GRAVEN" is the sum of the graves available for a given row. There is no table where "Rij naam" is unique. the sum of the graves ( positions) available wil be calculated by a script when defining the graves (positions). I want to deal with it using a script containing a find and loop statement. I didn't figured that out as well, at this point I'm enetering the values of TELLING_GRAVEN and AANTAL_GEBRUIKT manually. The result must be: when I'm entering a new reservation I only want to see the available rows in the valuelist. I hioe it this will make it more clear. HTH Adri
  6. Hi all, I have a three table situation. 1. Tablename "Begraafplaatsen" 2. Tablename "Graven" 3. Tablename "Reserveringen" In "Begraafplaatsen" is a pKey field begraafplaatsen::id. In "Graven" is a fKey field id_begraafplaatsen. This fKey field exist in "Reserveringen as well. There is a one-to-many relationship between begraafplaatsen::id and graven::id_begraafplaatsen to show only the relatedvalues of a specific record in "begraafplaatsen". This works fine. In Table "Graven" Is a field "Rij naam". The values in this field exist more than once because for every "Rij naam" more then one position is available. The sum of the positions is stored in a number field called TELLING_GRAVEN. In table "Reserveringen" a is field "AANTAL_GEBRUIKT". In this field is the sum of taken positions stored for every "RIj naam". What I want to accomplish is: Only show the values of "Rij naam" if begraafplaatsen::id = graven::id_begraafplaatsen and reserveringen::AANTAL_GEBRUIKT < graven::TELLING_GRAVEN Setting up my relationships this way it shows the wrong data. I've tried it in several ways but I can't get it to work. Where did I go wrong? BTW The data is in separate file (using external data source). Any help is much, very much, appreciated. HTH Adri
  7. Thanks that does the trick. Even more simple as where I came up with.
  8. Hi all, I've created in my solution a portal for navigation purposes (see attached images). For the user it is clear on wich record they are when the portal row is highlighted. And beside that it is visually atractive. This kind of highlligting do we see on websites all the time. For this highlighting I'm using conditional formatting. The formula is: If ( Table::id = TablePortal::id ; RGB ( 204 ; 204 ; 153 ) ; Self ) where TablePortal is a TO from table with a cartesian relationship. A strange behavior occur. When I enter a number in the displayed field on the details area the row stays highlighted in the portal when i click another record. Any idea why this is happening and how to prvent it. It is possible that an nummeric value is added in the field to display. hth
  9. Hi Comment, I feel so stupid but for some reason I am unable to get it to work. Is the join table a real table or just a TO? My general Items file has a relationship with another table (license) so the General Items can be added at the top of the chain so to speak. I have set up the relationships in several different ways (even with an extra TO GeneralItems 2) but one way or the other it will not work as I want (or as you described). Can it be caused by the fact that my data is separated from my app (UI and logic) file? I am unable to create a lookup. I am unable to make an unique relationship. I was able to set the portal up to show the correct records but at that point I was unable to add records when they didnot exist in the General Products table. The portal was only showing the field values from the General table and that is not what I am aming for. Short.... I'm lost. Can you provide me with an example wich I can study? I'm sure that it will be very helpfull. Thank you very much.
  10. Hi Comment, I have implemented your suggestion and it works fine when I'm adding a record. The validation is handled by the code you provided. I only had to make sure the used List function evaluates every time a record is added (commited) or deleted. I extended the script so that if the desired value exist in the general products table the corresponding fieldvalues are added into the LocationsProducts table. Works fine. However there is one problem. When I am adding a record to the LocationsProducts table and the UniqueName field (FieldName is Code in the pictures) validates, the script performes a search in the Products table. When it does not find a corresponding record I want to add a description (omschrijving) and price (Stuksprijs) manually. When we return to the orignal layout I find the portal sorted with the Description Field active in the WRONG record. See attachment wrong.png Is there a way to correct this so I am getting the right field in the right record active? See attechment right.png I hope to hear from you
  11. Thank you for your reply. Searching the forum to move forward on this problem the thought of a join table came up already. Never used it so its a challenge (again). I will try to work this out. I will let you know. Thanks for all the time so far.
  12. The FM fieldvalidation is on a extra field wich concatenates the value of the ParentFieldValue and the UniqueNameValue Otherwise we are not able to allow duplicate UniqueNameValues in deifferent parent sets. Yes, that is what I meant. I will try to describe it in a clear way. Imagine this: We are in browse mode working with parent Red and want to add the value Alpha. We enter it in the field UniqueName. The validation script returns OK and accepts it (it is does not exists in the "group" Red.) The solution checks if the value Alpha exists in other parent "groups". The value does not exist in another parent set The solution takes us to the next field (Value) If it does exists there are several possibilities It exists one time in another parent group The values are added in the child record of parent group "Red" Probably using some variables and SetField scriptsteps It exists more then one time in other parent groups (in more then one parent group) Example: Parent Blue UniqueName: Alpha Value: 100 Price: € 10,00 Parent Pink UniqueName: Alpha Value: 100 Price: € 10,00 Parent Yellow UniqueName: Alpha Value: 100 Price: € 10,00 Parent Green UniqueName: Alpha Value: 100 Price: € 10,00 The solution recognices the identical values in record one, two three and four and traet it if it exists only once -> the values are added in the child record of parent group "Red". It exists more then one time in other parent groups with differences (a mix) on field level. example: Parent Blue UniqueName: Alpha Value: 100 Price: € 10,00 Parent Pink UniqueName: Alpha Value: 100 Price: € 10,00 Parent Yellow UniqueName: Alpha Value: 200 Price: € 10,00 Parent Green UniqueName: Alpha Value: 200 Price: € 50,00 The solution has to come up with a dialog or popup window allowing the user to choose from: UniqueName: Alpha Value: 100 Price: € 10,00 UniqueName: Alpha Value: 200 Price: € 10,00 UniqueName: Alpha Value: 200 Price: € 50,00 It has to show every unique set of UniqueName, Value and Price only once allowing the user to select one of them. The fieldvalues are addes by doubleclicking the appropriate record. The one the user wants is not displayed The solution has to give the user the opportunity to cancel out. Doiing this the Popup or dialog is closed and the user is taken to the next field (Value) to add values manually. I hope this will make it clear because I am running out of possibilities to describe it (perhaps due to my limited knowledge of the English language). Thank you for your patience and willingness to invest the time to help me out. hth
  13. If you are at at parent record 'Red" and you want to add the child "Alpha" it is only possible when it is NOT present in the current set of parent "Red". When it does exist then the validationscript stops it all (this is the script you helped me with at the top of this topic). It is only possible to add this record "Alpha" when it does not exist in the parent 'Red" but does is Blue or Green. When it has the same values in each field (or it exist only once) the solution has to add it automaticly. When it has the same UniqueName but not exact the same fieldvalues the solution has to provide the user with an option to add the right one by doubleclick. So (forgive me if I didn't unerstand you the right way) as I read it is just the other way around. the thought behind it is that the branches can use the records from eachother but also beiing able to add (or add and change) records with the same UniqueName to fit their own needs. Case is this: I'm designing a solution to manage graveyards in The Netherlands. It is possible that there is an item what is called: "Fee for renting a grave for 20 years", costs € 4.500,-. That item will have a UniqueValue, lets say RENT20. It is however possible that one organisation manage more graveyards in a city (or given area). So it can be possible that the example fits the needs exactly for graveyard one, fits not for graveyard two because the price is different and fits not in any way for graveyard three because the description and the price differs but the UniquValue is the one the emloyees came up with because they will remember as the right one for their given situation. So, there are a lot of buts and ifs and elses and I'm trying to figure out a way to solve it. Note: every single record in the Child table has its own unique identifier. hth adri
  14. Thank you for your quick replay. No, I don't want to allow duplicate values for the same parent. I want the possibility that if a value exist in the child table that it can be added to another parent. So the duplicate fieldvalues will be allowed in the child table. However those duplicates exists only at the level of some fields. Strictly speaking are the (visible) duplicates unique records with their own unique identifier. If there are more "identical" records, all existing to different parents I only want to use or display one of them. Sorry I wasn't clear (again) I hope it's clear this time. It must be my poor English. Thank you for your time to help me out.
  15. Sorry for this late reply, but I've been away for a while. What I want to accomplish is this: Validation is OK so far. I want to extend the script with the following: When the field UniqueName exists one time in the child table (but with another Parent record) the Fieldvalues are copied into the record I'm adding. The user is able to edit the record. When the UniqueName exists more then one time the field values in those records must be compared (UniqueName, Value etc. If they are the same in the records the values are copied in the record I'm adding. When they ar not the same the user must get the different records on screen by a layout showing a list. Unique records only. The user must ba able to doubleclick a record to copy the values into the record I'm adding. By clicking cancel the popupwindow closes, the Unique name is accepted and the cursor moves to the next field. I was working on it and came to the conclusion that it was gonna be a large script with a lot of Find routines, switchint to different layouts and so on. I think it wil be slow. The question was: is there a way get this done in a quick way? I hope to haer from you. Adri
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.