Newbies gegebene Posted March 4, 2015 Newbies Share Posted March 4, 2015 Hi to all, I'm new of this forum and new of the fm software. I'd like to ask you a little advice if I can: I have to make a warehouse database where I can store my werehouse items, and official prize catalog. These catalogs will be imported from xls files. The problem is that I have to assign for each item in my warehouse an item from the catalog (so i can see the formal description of the article). These catalogs are very very very extended something like 6500 record for each catalog. So do you think: 1. I have to make 1 table for the catalog that contains all the record of all catalogs with an ID an Brand. so i can make search through one single table. 2. I hate to make 1 table for each brand contained in the catalogs so I can update them easily in future. But I don't know how to search between multiple table.. how do you think its better? Thank u in advace and sorry for my horrible english Link to comment Share on other sites More sharing options...
Wim Decorte Posted March 4, 2015 Share Posted March 4, 2015 You need 1 product table, all the catalog entries go in there. Don't create a table per Brand. "Brand" is just a description of a product. Link to comment Share on other sites More sharing options...
Newbies gegebene Posted March 9, 2015 Author Newbies Share Posted March 9, 2015 You need 1 product table, all the catalog entries go in there. Don't create a table per Brand. "Brand" is just a description of a product. Ty for your kind answer...so I did like u said and its all good. now can i ask you something else? Im go crazy to find a solution to make a "script" or something similar to search text input from a text field and output to a portal or something similar. I really don't know how to do that... thank u in advace again and sorry if my question bother u Link to comment Share on other sites More sharing options...
voltron2112 Posted March 14, 2015 Share Posted March 14, 2015 Searching on a portal is harder then searching on a list view. If you need to search a portal, check out this article http://www.soliantconsulting.com/blog/2013/03/dynamically-filtering-filtered-portals. It has a great example file you can download to help too. Hope this helps. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3330 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