1 of 1 people found this helpful
under the Resources menu on this forum, you'll find all kinds of goodies!
This may help you with what you need:
"How To: All-in-One Parent-Child Layout"
You cannot mix Form and List, but the "simulation" of Form View with a Portal "pick-list" is close!
But you are referring another situation. My simple requirement is maybe a big issue here. I have a button on my Product form which open the product table in list view blinking in a field to enter some name of product. After that I press Apply Find button and it shows a list of records with that names. I click one name and it open again the Product form with that record. Its quite Ok but it is doing the same job taking four steps.
The sample database I suggested has only one page which can shows all five forms along with their list view. Just to click the shortcut, Contacts, Products, Invoices, Letters, About and it opens that form on same place. Working like tabs but no tabs. Each form with detailed list. Just click on any value in the list and same record will open the form beside.
That mean it is possible in FM. You can not say "You cannot mix Form and List".
I have used multiple windows for "form" (with portals, likely) and open window for "pick list" (List View). It is NOT pretty, especially if you are using a button to go to the list (opens the window) and once selected, getting the value back into the proper field (in a portal or not).
if you don't like the "pick list" to be a portal that is always shown, there are sliding panels that allow these to be shown/hidden until needed. And there are pop-ups that can show a portal (temporary small overlay) for your pick list. these go away once selected.
In any scenario, the portal, of course can be filtered to show "found" records from which to pick. For my clients, for example, the list is filtered by a product manufacturer or the type of product or even a price range for a product (from different distributors). The flexibility of this is very useful.
Going to another window and finding the values is not the hard part. It's getting the value back into the field from which you started. Is that a fair assessment?
Thank you again Baverly
I am doubtful that you still understand what I want. This only what MS Access have "split forms", showing a table together with form like view in upper portion and list of that same table in lower portion. And Brilliant Database have each form view by default like this, upper portion with list of records and lower one record as form view.
Here I searched a lot in FM community forum. Many members asked this question before but never answered correctly.
Big programmers of FM giving other type of solutions like nested layouts. some of them annoyed that why people asking this question again and again. They referencing and presenting FM file to view. But all have different thing, different usage. I tried myself but not able to insert a portal of its own table. It only allow a portal of child table. If I create a second occurrence of that table in relations and make portal of that second table, it only shows the related record, one for one. You are suggesting a dropdown or popup list, that I think is for field level to fill that field. If you mentioning some other thing which is exactly serving my purpose (as split form) then please refer any book, FM file or video as I referenced in my original thread.
Thanks for your all replies.
In your first answer you given a link for a document. That is completely different thing, also other programmers suggesting similar solution. A parent then child then grand child with selected record field. Selecting a record in one portal which shows its child in second portal etc.
No split views. I have used the Header part to show form-like on list view with rows below.
Sent from miPhone
You can not say "You cannot mix Form and List".
Sure you can. It's a fact.
You can mix PORTAL and form though.
The file you mention (Corporate Design Pack) uses a PORTAL on the left side.
Also called master-detail.
If you don't know how to set up a self-relation; then you should study a little more.
You might also look here:
Edit: as Bev has made clear, you can put form fields in the header (or footer).
But side by side; nope, can't do that.
Thanks you Beverly!
Now you have suggested a simple solution and I found similar in an other thread where it was suggested to use footer for form like view.
Actually a database creator's job is to provide a user friendly environment. And when he see some thing new and interesting in other solutions he want to adapt it.
Hi Mr. Rebertson
The Corporate Design Pack file is a big one you know(38 mb) with a huge numbers of records and relationships. A long naming and 63 fields in one table. So a new person like me puzzles very soon.
Thank you for suggesting a link. I will check it soon.
I have also used Leading (or Trailing) Grand Summary (with List View) for those times when I want "form-style" view to show when scrolled to the top (or bottom), but doesn't take 'real estate' all the time. Thus showing more of the list if it is many records/rows.