Newbies jonn89 Posted January 20, 2011 Newbies Share Posted January 20, 2011 Hello, I am using filemaker pro 9 to enter marks for students, and the mark sheets are supplied as excel spread sheets. Right now I am copying the student number from the spread sheet, and pasting it into the search box, then clicking new, and keep doing that until I have entered all the student numbers, and then I click search. This works fine, but I am sure there is a way to highlight all of the student numbers from excel, and then search them all at once? As in highlighting the whole batch of student ID numbers and searching in filemaker as opposed to individually copying and pasting into the search function... Also, once I have done this I have to type in the students' marks individually, is there also a similar function which allows all the marks from a spreadsheet to be copied and pasted into Filemaker all at once? Sorry if this issue has been addressed previously, but I searched and found nothing as I didn't even really know what to search for. Thanks for anyone that can help. Regards, Jonn Link to comment Share on other sites More sharing options...
comment Posted January 20, 2011 Share Posted January 20, 2011 See 'Updating matching records' here: http://www.filemaker.com/11help/html/import_export.16.11.html#1027964 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4845 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now