Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About GeraldV

  • Rank
  1. Justin, I've updated my profile to include my email.
  2. I am looking for a good starter solution for a Business Directory database. I have searched, but I only seem to find ones that focus on Contacts. An example would be a listing of an Umbrella corporation, its various Aliases, Entities and Subdivisions, their Branches/Locations, the products or services they provide, and lastly their contacts. Due to budget, it would have be a FM7 solution. If someone could point me in the right direction, it would be greatly appreciated. Thanks.
  3. Same, but based on type, would also include 1 or 2 list portals of related items and extra attributes. It would basically be just a more in-depth view. I could just skip all that and place the all the various portals and attributes on the Main window, but that's just not very clean looking. Really everything "could" all be done from one form layout, I am just trying to narrow things down for the user.
  4. Ok, I think my brain is preventing me from including all the pertinent information to the question. I would be switching from a form layout to another form layout, both based on the same table. So, if I am on record id#21 in the "Main" (unfiltered, all records) form layout, and I click on a fake tab (a button scripted to take me to the "Manufacturers" form layout and find all records of type "Manufacturer"), I would like it to "update" that form layout to put me on record id#21. So really, I would like the script to "remember" what record I am on, take me to the new layout, "filt
  5. I was following the suggestion by you and bcooney with buttons styled as fake tabs. Reducing the found set by type= "(insertnameoftype)". So let's say I have 3 tabs(layouts) Main (unfiltered), Type1 (find type1), Type2 (find type2). If the user is viewing in Main and wants to view a record with all it's related info, they would click on the appropriate "tab" and be taken to that layout. Problem is that because of the find being performed (to limit files of that type), it resets the displayed record to the first record found in the find. I would like it to switch layouts, limit the type
  6. I really appreciate all the feedback and please DO try to convince me. Even though I've been trying to work out the basic functionality, nothing has been set in stone as for the actual model to use. I know I have 7 categories under which a company may be placed. A company may have sub-companies (children). A (parent) company may have related tables based on the category (ie-a Supplier would list its Products, a Manufacturer would list its Brands). There are other certain attributes which will only be available to some categories, but every company does have the basics of name, addre
  7. Actually, I am trying to keep it as logically simple as possible. I would never want to generate a report/export of just the common data unless it was an overall dump. I WILL have to generate reports/exports based solely on the "type" and it's related tables. It would seem easier to be able to do that based on the supertype model. Plus, it would also limit access to the related tables so attributes from one type would not "accidentally" be assigned to another (this would include Parent/Child relationships). Things were much simpler before I started thinking about trying to make it idiot
  8. Actually, I could set up the database either way. There are a lot of other tables/attributes that are related to the individual types, but I think for the sake of importing, one main table would be easiest ( although, for exporting, the supertype would be much easier. ) Then again, it really wouldn't really matter which I went with if I could rely on the end users not making a goof. I think I really need to weigh the pros and cons of both models ( maybe a good night's sleep would help!!! ). How hard would it be to create script that could "move" a supertype? ...and, no, there ca
  9. Then that would bring me back to my original post, unless there is a way to do the supertype solution in reverse, starting from the common table, and populate the type tables based on the user's selection. (I'd prefer to use the supertype solution, but I KNOW my user base)
  10. Ok, but when examining your CommonTypes example, I see no way to be able to move records between "type" tables. My concern is: if the user creates the entry under the wrong "type" then there is no easy way to move that record to the correct "type" table.
  11. I had already looked at the Graham Method examples, but I am kinda (ok, extremely) confused. The only way I could see what I want to occur is to create a different table for each "category", but then the user would have to know which category the company was to go into before creating a new record, and thus start out on the correct layout (ie-Manufacturers for a Manufacturer), rather than just entering the company data and figuring out what category to place it in later. I must be completely missing the concept! Is there an extremely basic example available? I've been trying to recreate t
  12. This might not be the correct section for this post, but since I am now working on my layouts... I have a single table of Companies. Fields include Name, Address, Phone, etc., and a Category field. The Categories are set from a custom value list (Manufactures, Suppliers, Agencies, etc.) In a basic layout I can view all records and page thru them. I would like to set up tabs, based on the Categories, and view the same info, but restricted to the particular Category. Is there a way to do this with a single table?
  13. Ok, this is what I decided would work for me. A combo of comment's PortalToPortal and DwindlingVL techniques. This will allow the users to see what has already been selected, delete unwanted items, add new items, and avoid duplicates. Only problem I am having with this now is: I cannot make the delete box go away when there are no items in the portal. It's gotta be something silly that I missed somewhere, but even when recreating the file from scratch, I manage to duplicate the problem. MultiValueSelects.fp7.zip
  14. Thank you for that suggestion. That is much better than what I was envisioning. Plus, I won't have to deal with trying to display a list of 422 checkboxes on the screen, they barely fit even at 6pt. Again a big THANKS
  15. Ok, I think I understand...maybe I should point out that it took me a week to figure out that comment's DwindlingValueList example had a script attached...I can figure out how to display the data in the format, but I think I am confusing myself about how to actually go about doing that. Here's what I have so far. I can display the items already in there, but then can't modify the list, and I can display the list and modify it, but it doesn't show what's already in there. I know that's probably a bad relationship on my part. Can anyone point me to an example of the looping/GetValue/Add re
  • Create New...

Important Information

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