Three Part Search Problems
I am fairly new to filemaker and have run into a few problems. On my main layout page I have created a self referencing portal that contains the following fields in order:
I am using the portal, because I was meant to believe that is the only way to have a list where the user can keep adding lines of information. *It is unknown as to how many lines will be needed for each day. *On another layout I have set up the same fields as a means of entering new records for the main page. This is where I have start to run into a few problems. As the post heading suggests, there are three issues I need help with. I will separate them into parts to make it easier to follow.*
The main page is set up as a way to view the activities for a date. When the user clicks a button, it takes them to the second layout (Add details page). Again this has all the same fields as the main page. When the user enters all the info and clicks the ok button, I want it to search all previous records, find the date they have entered, and if it exists, and the information on the next line of the portal. If it doesn't exist, create a new record with the information. Right now it is creating a new record for everything, even ones with the same date. Can some one suggest a script to help with this?
Search on main page
The primary users of this database will have very basic computer knowledge, and I know that they won't understand the find function and just try to enter a date on the drop down calendar, thus messing up all the records. I know I can set up the OnObjectExit script trigger on the date field, but I am not sure of the script to use so that when some picks a date from that field, it automatically finds the record associated with that date and lists all relevant info in the appropriate fields.*
Copy or move portal line
As I mentioned earlier, the above fields are located in a portal on the main page. I have buttons on each line that when clicked, take the user to the Add Details page. Sometimes it is necessary to move one of the lines to another date (I.e. A client has changed the date of when a machine is needed). Rather than delete the whole line and retype everything, I would like to have two buttons of the Add Details page, one marked 'copy' one marked 'move'. Obviously the copy button copies the selected info to another *date record and the move one moves everything to the new date and clears the information on that line from the old date. I am not sure what the best way to do this is. Maybe have a window pop up asking for the date to be copied or moved to.*
Any help you can provided on all of the above problems, would be most appreciated.