rister

Hi I am trying to import this excel sheet into a modified filemaker template for time billing. I am not sure how to make the relations so that when I import the line items, it creates one record per billingID on the time billing table. I've tried a few things but so far nothing has worked. Any help would be much appreciated. I tried making a script too but it only made one record. Importtest.zip

Thank you so much!!! I'll try all that

I recently installed our filemaker databases on a server instead of a single computer, so the image path no longer works. I am not sure if there is a way to change the image path, or how to even tell what the image path is. Is there an easy way to do this?

I am a little confused. I made a join table and in my portal I can select more than one category in multiple dropdowns but can't search the portal categories. I'd like only one dropdown menu where I can select multiple items using the Shift key and then be able to search for each of those selections. Perhaps I am just not doing this right...? I included what I tried if anyone can point me in the right direction... I know it's possible in other databases/languages, just not sure how to do it in filemaker or if it's even possible? test3.fp7.zip

They don't want to use checkboxes because there are like 50 categories. It would take up way too much room. Does anyone know if there is a way to do what I want to do? Basically each record has 1 or more categories. Very similar to tags. It would be nice to be able to select more than one which would simply show up in a field on the record.

I have a question. I know you can choose multiple selections in drop down menus when holding down the shift key but after I do that and let go, only one of my selections shows up in the field. Is there a way for all my selections to show up? Thanks for any help