Form and List View at the same time?

[tdiaz]

I am in the midst of designing a specialized database of sorts ...

One that will allow me to enter items and immediatly sort a list view placing that item or closest match (alphabetically) in the center of the list view.

Then I can, if I want- select that record and have the data populate the form view that is on the screen at the same time and make changes to it or make it a new record.

------------------

(Form View )

[item Name ] [item Location ] [item Category]

[item Description] [NEW Record] [CLEAR Entries] [sAVE Record]



(List View)

Item Name  | Item Description  |  Item Location  | Item Category

Item Name  | Item Description  |  Item Location  | Item Category

Item Name  | Item Description  |  Item Location  | Item Category

Item Name  | Item Description  |  Item Location  | Item Category

Item Name  | Item Description  |  Item Location  | Item Category

---------------

Can FileMaker do something like this?

[-Queue-]

You can put a portal on a layout in Form View to simulate a List View of related records. You can then put a button within the first portal row attached to a script step of Go to Related Record ["relationshipOnWhichPortalIsBased"] to select a clicked on row's record as that which appears above the portal.

[tdiaz]

Cool, thanks - portal is the term for it.

According to the docs other sources they usually say that a portal is used to reference another file, so I'll see if it should reference the same file, if not- I'll make this thing two files then. Sounds like that should at least get me past this point.

Thanks!

[Sergeant Ron]

you can use a portal to reference records with in the same file. Make a Self Join Relationship. for instance define a field as a calculation called constant1. Then the calculation would be entered as "1" make sure you use quotes unless you denine the field as a number. It shouldnt make a difference if it's text or a number though. Then create a relationship relating the field in your main file to your relationship (referencing the same file of course).Since they will always be equal, you now have your relationship. You can then sort the relationship alphebetically by the field that you wanted it sorted by. Add a button to portal to go to related record and you should be on your way. If you don't like looking at the buttons you can always right click on one of your fields and define it as a button and just change the text color to define it from the rest if you wish. I hope this helps. Ron

[tdiaz]

What I have now is shown below, the portal in the lower half of the layout shows me the records;

I'm having a hard time trying to figure out a few things still,

1) I would like to have clicking on the item in the portal bring that record up in the upper half of the layout. I'm assuming it's going to be a script item, the filemaker docs are not friendly to me..

I would also like it to update the records displayed in the portal to the closest position that the record currently displayed shows- and show that in the portal from the center of the portal window. IE, if I enter something that begins with "Transwarp", it will sort the portal to the other entries that begin with Tr... or closest alphabetically.

I have the portal set to sort on item name alphabetically descending. But it always shows the top 10 records only.

The other thing is that larger picture to the right, and the four smaller picture boxes on the left side. Would I need a script to get the larger view on the right to just show the one I select on the left? Kinda like eBay displays the thumbnails and then clicking shows the larger one.