Jump to content

many-to-many relationship problem


susansan
 Share

This topic is 5684 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I'm using the inventory template. The problem is that I have a many-to-many relationship that I don't know how to handle in Filemaker (I'm new to FM, but have database design experience). Each product in my Inventory table can be assigned to more than one category. A category can be assigned to many products. So, I built a bridge table called Inventory_Category to hold a concatenated key of the InventoryID from the Inventory table and the CategoryID from my Category table. Now when I'm in form mode and I'm entering a product, I need to be able to click a button (or do something) so that I can add multiple categories to it. How would I build this and have it insert the current InventoryID and the CategoryID I specify into my Inventory_Category bridge table? The CategortyID being entered must exist in the Category table. Any help is appreciated!

Link to comment
Share on other sites

Thanks! Your file seems like what I need for my solution, however, my export needs are different. If I have an item record that has multiple categories, I need it to export with the redundant data as follows:

Sterling Silver Ring 19.99 all-rings

Sterling Silver Ring 19.99 stoneless-rings

Sterling Silver Ring 19.99 pave-rings

etc.... for all my products. Is there a way to do this?

Link to comment
Share on other sites

This topic is 5684 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.