And what exactly is going wrong? Is the field set to look up a value coming up blank or looking up the wrong value?
What are the field options and realtionship (need to know exact settings here) that you have set up?
Thanks for your response.
Using the FM template Contacts Management, I have created a database which has 3 tables for recording student information - Contacts Management, Enrollements & Notes; from these I have
From Jim Gurley 15/07/12 "Only one of your tables is the Prime [datebase term for creator if the Registration Number]. The Contact Management table appears to be the Prime Key [kp] in you relationship tables. They are related by Contact ID, not regeistation number"
The Registration number field in the is set to look up the value from the Contact Management table in the Enrollment and Notes tables and it is fining the correct value - even if I take the Rego number out of these tables that will not stop the extra record being created. The problem is I have not connectd the tables so that only one record is created.
When I create a new record (eg Registration #1030) via the Contact Management layout all goes as it should until I go to the next layout (Enrollment information) to add additional information to record #1030. The new information causes a new record to be created, this record will have the same Registration Number (eg # 1030), this record will hold information from the Enrollments layout only however this same information is also held in the first record created as it should. There are now x2 records for #1030, when a new record with a new registration number is created the the process is repeated, so there is now x4 records two with #2030 and x2 with 2031, the next record created should be 2032 but in fact the Rego number is now 2034??
The relationship between the layouts/tables is obviously incorrect and I am not sure how to fix this?
I hope I have given you enough infrormation.
Can you post your DB like you did last time.? That is how i found the duplication of sequencing.
If you add the information to a record using a Portal, you will create a new record if it is entered in a blank portal row.
I have just sent the database via Sharefile.
Sorry for the long delay in responding, we have had internet server problems...!!!
Can you tell me the best way to send the file to you?
Check your Jenny "inbox" for FMP users at top right side of this page next to "signed in as". I sent 2 notes to you with ways to do it. Two different emails, depending on your file size.
I got the file and found what is a common error.
The Relationship graph establishes the potential relationship not a automatic match.
You must have a least one match to communicate between tables using a Relationship graph!
I modified your scripts to pass the Student Registration Number to the Foreign Key Registration Number via Script Parameter.
This now establishes a MATCH and the Tables can communicate.
If no Match, you get a Empty set in your scripts.