M. Savolainen

This is how my relationship looks like now. Example file can be downloaded from HERE. Relationship works until I have categories that should be related to more than one mainline. I have two mainlines called clothing and cloth/fabric. Then I have category called Shirts. As T-shirts are fabric and clothing, it should appear and be related to both mainlines, how to make it so? Currently its only possible to join it with one mainline. Example file describes better what I am trying to achieve. Comments included. How do I make it work? Thanks in advance. Update: I added a jointable to fix the problem, but is this the only way to go? Or is there a better way? Im still having several problems when trying to make data select for items (valuelists won't sort correctly). First valuelist should show all mainlines, second should show only related to mainline (that works), but the third valuelist shows all subcategories, not only the related ones...

Great, thank you very much! Now I get it :o

Here's the file with descriptions how the db should work.... portal_Copy.zip

Thanks. I succesfully created portal and made the relationships... Now when I enter item serial number to the field on Usertable I won't get item type or item size... How to fix it? And thanks for the links too I will read them What Im trying to accomplish: You insert only items to item table (serial number, size and type) Then later on when user needs the item I will search the user from user table and enter only the items serial number and it will show item under user record (and all the info that specified item/items has.

Hello! Another fairly new Filemaker user. Im trying to make a database that shows which items users have. Im currently using two tables. Table user has fields; username item1 item1type item1size item2 item2type item3size item4 item4type item4size etc... Table items has fields; serialnumber type size I have tried to use lookup for item fields, but once I enter item serialnumber to item1 field => item1type and item1size gets value from table items, but so does item2, item3 and item4 (and the value is same in all fields)... and I cannot enter multiple serial numbers. What am I missing here? How can I make it work, so that after applying item1 serialnumber, all other fields stay empty and I am amble to enter another serialnumber to item2? How should I set the relationship between these two tablers? Thanks in advance.