ContributionsMost RecentMost LikesSolutionsRe: Importing data into child table and linking it to parent tableThank you. Unfortunately , although Part Number is the key field to me, I was not familiar with the concept and the current Key field in quickbase seems to be a record number link to the order in which I filled the master table. Can I change the Key filed now? I have 5 other child/parents relationships that work fine and I do not want to mess everything up...Importing data into child table and linking it to parent tableMy system has about 100 parts identified by a Part Number in the parent "configuration Table". Each part has 5 to 10 documents that I would like to archive. I created a child table named 'documentation' which gather records called 'documents'. I created a lookup field to the parent "configuration table" which is the field "Part Number". Because I have so many references to create, it seems easier for me to list all the documents under excels and to import it them all at once. The file I upload has the following fields: Part Number (My lookup field) / Document Number / Document Type / Link to the document... My problem is, when I upload, all the documents end up linked to the same part (The one listed first...). That seems like a pretty straightforward issue but I can t find a way around.. Can anyone help? thanksRe: Display field of most recent child record?Hi Danimal! I am actually going right now through your pasties #314 (which brings a functionnality that I expected to be built-in but is apparently not). I may have to come back to you about that too. Anyway thanks to both of you for sharing your expertise. On-line support told me for both questions that is was just impossible to do in quickbase. I am glad to see that there are ways around..Re: Display field of most recent child record?Thanks! I realize it is much different from what I would have done on excel/matlab..A whole new philosophy to embrace ;-) I have done my homework and managed to retrieve the latest status which was my initial intend. Thanks a lot for the explanation!Re: Display field of most recent child record?Hi! My apologies for the very naive question but how/what is the syntax to get the maximum record ID#? I created a field and typed ' Max([CI-PN ID#]) ' under the formula field but the syntax seems to be incorrect. How do I get a max of a record? And more generally how can I get the max of a table or a column of a table? Thanks for your help