tracking inventory...sort of

[pacintern]

I'm working for an organization that want to keep track of art works by artists. I'm attempting to create a button that will allow a new art work to be entered under an artist. The goal is to have each record contain information about the artist (which will be the same for each piece of art entered) and information about the piece of art work.

What kind of script will create a new record, keep the information about the artist but clear the information about the art work so that new information about a different piece of work can be entered.

please help

[HiredGun79]

What I'd do is have different tables. . have an artist table that tracks the artist's information - All the info that's about the artist. Then I'd have an "works" table where all the art pieces would be stored. Have an "artist_id" field in the "works" table and put the correct artist id in that field to relate the artist to his work.

In the works table put all the information about the work plus that artist_id field.

To make it work, you'll use a portal on a layout that is based off of the artist table. In the layout you can put whatever fields from the "works" table that you want. . perhaps the title of the work, the medium and the year created.

Then you can make two buttons.

The first button will be an "add work" button that will allow you to enter in another art piece by the artist. The way you do this is to use a script parameter. That is, a variable that gets passed to the script by the button. Pass the "artist_id" field. In the button script you simply go to a new layout, based on the "works" table. Create a new record and set the "artist_id" field in the "works" table to "Get ( ScriptParameter )"

That sets that field to the same artist ID as the artist of the work.

From there, the user would be free to enter in all the other information about the art work that they want. Perhaps you'd make the fields in the portal on the artist layout required, so the portal looks good.

Make a button at the bottom of the "work" layout confirm the records and go back to the artist layout.

Voila! You should see the new work in the portal now.

The second button would be a button that would take the user to all the information about the work. Make a rectangle the same size as one row in the portal. Set that button to go to a new layout "view_work" Make the button transparent, so it will work when you click on the portal row. In the script, use the "go to related record" script step and use the "view_work" layout.

In the "view_work" layout, put all the fields you want to display about the work, like a container field with a picture of the work.

Again, make a button at the bottom of the layout that will take the user back to the artist page.

I hope this helps you out!

Please respond with any questions, I'd be glad to answer.