Drag and drop text is a preference setting in filemaker so you can easily drag text from one field and drop a copy into another.
If you are using FMP 10, you could then complete the process with a script trigger attached to the field that receives the dropped text. Your triggered script could check to see if a person has already been assigned to a tent and such...
Are triggered scripts available in FM 9 pro adv?
No, that's a new feature that comes with FMP 10.
The closest to that interface that I can conceive of with FMP 9 and eariler would be a two step process. You'd drag and drop the text, then click a button next to the target field to perform the assignment script.
Alright, I guess what I will do is just place all the tent fields on the layout, and use a value list so they can select who is in which tent. We don't have that many tents, so the user will be able to see all assignments on one page, so that might not be an issue.
However, the problem I am having is with the value list now. I have it pulling from another table (may be the problem) but when I set it to use the "full name" field (calculation combining first and last name fields) it will only display one persons full name. However, it will show all the members names if I set the value list to only first name, or only last name. I can make it "also display values from second field" but when the user doesn't have that drop down open, it won't display the second field.
Could this be because "full name" is a calculation field?
"Could this be because "full name" is a calculation field?"
No, I use calculated fields as the source for value lists frequently. I'd check to see if this calculation is a stored, indexed field. (Open the specify calculation box for the field and click storage options...)
I cannot get it to display properly no matter what I try... indexed, not indexed, the value list pulling its values from the relationship table (Members Tents), or simply from Members table. I can't think of why this wouldn't work.
I figured it out.
The calculation results were set to number, not text.
In every other use, those calculations worked as being stored as a number. It only created a problem when trying to use it as a drop down list.
Check to be sure fullname is defined as follows:
In members table.
FullName, FirstName & " " & LastName, calculation return result is text.
To see if the calculation is set to return text, open it's specify calculation dialog and check the drop down in the bottom left corner. If it's set to return 'number', that could explain what you are seeing.