SFSDIT
asked on
Filemaker Form
When I enter data in the HS Form(look at the first pic)
it goes to the Followup Form Down Below (look at the second pic)
However if I enter data in the BS Form, (look at the third pic)
it does not go to the Followup Form down Below but shows only data for the HS Form
(Look at the last pic)
Can you tell me the reason and solution for this??
Thank you.
HS.jpg
FForm.jpg
BS.jpg
FForm2.jpg
it goes to the Followup Form Down Below (look at the second pic)
However if I enter data in the BS Form, (look at the third pic)
it does not go to the Followup Form down Below but shows only data for the HS Form
(Look at the last pic)
Can you tell me the reason and solution for this??
Thank you.
HS.jpg
FForm.jpg
BS.jpg
FForm2.jpg
ASKER
When all data is filled in, it automatically saves in the table.
The Followup form takes values from HS Form but it does not bring any values from BS Form.
So what script/trigger do I need?
The Followup form takes values from HS Form but it does not bring any values from BS Form.
So what script/trigger do I need?
As I say, it sounds like a script is happening to take you from the main form to the followup form, but I really don't have enough information to fully understand what is happening here. Are you able to post an example file or a clone of your database with a fake record of two in it?
Hmmm....I would see if the followup form is using lookups, then review the relationship for that lookup.
Fields will only lookup values based on one relationship. So if you are creating child records(the followup) via script from two different tables and populate the field that the lookup is based on with a value from table BS....the fields will try to lookup matching values from table HS. The record may or may not exist.
Thats my suggestion based on little knowledge of the system!
:-)
Fields will only lookup values based on one relationship. So if you are creating child records(the followup) via script from two different tables and populate the field that the lookup is based on with a value from table BS....the fields will try to lookup matching values from table HS. The record may or may not exist.
Thats my suggestion based on little knowledge of the system!
:-)
ASKER
I am attaching the relationship.(Relationship 3.jpg)
And clone of database file are like this. (Database.doc)
Relationship3.jpg
Form-Prob.doc
Database.doc
And clone of database file are like this. (Database.doc)
Relationship3.jpg
Form-Prob.doc
Database.doc
ASKER
Anybody who can answer to my question above?
ASKER
I would like to add more clarifying information as well as increase the point value submitted by my colleague.
1. Let me explain the database process again. Our teachers do service trips and they are using four different forms HS, MS, ES, BS (all created tables with key fields) for recording their data, event name, contact info, event ID (key field), etc. The four forms for request these service trips are all their own tables. What is being asked is that there be 1 follow-up form which acts as follows: The person leading the event puts in the event ID and then the form populates that followup form with the details of that event. I'm guessing through a portal. Our problem is that since each form has it's own Key field how do I get the portal to pull in the proper event ID and information if the key field are the same across the four tables. ie. a HS event could have a primary key of 25 and so could an ES event since they are in different tables. I'm trying to do this will a global table but my head is too scrambled to work this out right now.
Please advise,
Thanks
1. Let me explain the database process again. Our teachers do service trips and they are using four different forms HS, MS, ES, BS (all created tables with key fields) for recording their data, event name, contact info, event ID (key field), etc. The four forms for request these service trips are all their own tables. What is being asked is that there be 1 follow-up form which acts as follows: The person leading the event puts in the event ID and then the form populates that followup form with the details of that event. I'm guessing through a portal. Our problem is that since each form has it's own Key field how do I get the portal to pull in the proper event ID and information if the key field are the same across the four tables. ie. a HS event could have a primary key of 25 and so could an ES event since they are in different tables. I'm trying to do this will a global table but my head is too scrambled to work this out right now.
Please advise,
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for the input, been away for a couple of days and haven't been able to work through your suggestion. Willl try tomorrow and post an update.
thanks,
thanks,
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
If I'm correct on that then you would presumably need to alter the script that is changing the layout so that it looks first at what form it's starting on and then goes to the correct Followup based on the starting form.