Populating DB

[gtag]

I have a little project that I could use some expert help on. The project file is here - you'll see I've got a few tables and a few records. I want to be able to populate the String table with select records from the Transcription table. Can someone help me get started in the right direction with this?

Thanks in advance!

Grant

CLIP_DB_copy.fp7.zip

[mr_vodka]

Not knowing what the purpose is here (perhaps a one time thing), you could find the records that you want in Transactions and then import them into the String table...

[gtag]

the application is to create a database to help manage video assets. Ideally, I'd like to use the Clip Log, or detailed descriptions of what is on each clip, to assist in creating a first draft of a documentary. In other words, the Clip Log contains records of the pictures or words contained within each clip, as identified by Time Code and Tape number (combined they comprise the primary key for this table). So for example record 00112130410 (tape 001 at timecode 12:13:04:10) is a shot of a boat. Record 00112131020 is a shot of a car. I want my first shot in the scene to be the boat but I dont care about the car, so I'd like to figure out how to assign the boat to the table "String out".

The next level would be to figure out how to use SELECT text from the description field on the clip log. Example. record 00112201418 contains the description "hi. my name is ted, and I am way over my head in this Filemaker thing". I want to select everything but "in this filemaker thing" so that the description that is sent to the stingout table is only "Hi, my name is ted, and I am in way over my head". This is less important but would save huge amounts of time if achievable. Really all I need to do its be able to identify the records from the clip log and send them to the stringout table. I will need to do this several times.

[comment]

Perhaps something like this might suit your needs:

http://fmforums.com/forum/showpost.php?post/233897/

Software = Clips;

Computers = Versions, or Scenes in a version;

Installations = your STRING OUT table

---

BTW, you should use auto-entered serial numbers as your primary keys. Tapes and clips can be renamed.

[gtag]

I'll dive deeper into your database but at first glance it appears this will help me get going - many thanks!

I'll switch to auto-entered id - thanks for that tip too.

[gtag]

I seem to be having issues - if you remove all installed software, all uninstalled entries in computers layout disappear?

BTS_MASTER_DB.zip

Edited June 2, 2009 by Guest

[comment]

Yes, it's a version issue - see:

http://fmforums.com/forum/showpost.php?post/274656/

You need to change the "¶ " part into "¶0". Also, the calculation's result should be Text. And of course, the portal should be into an occurrence of the Clips table.