Record Help

[NDCinc.]

Filemaker Help 1:

I am trying to recreate a database with filemaker and one of the functions that I am trying to replicate is the ability to create multiple records within a field or table.

Currently I use a database for my debt settlement company where you can add multiple creditors and by pressing an “ADD” button it will create a new record line. In this record line it contains empty fields where you can look up a specific creditor and it will populate the field and can feel in additional information.

Once the creditor has been selected, the creditor name is an active link, that when clicked will bring the user to a table that contains all of the creditors information, specific to the selected creditor.

Example View:

Creditor: Account # Balance:

Chase 555444444 $3,264

MBNA 555577777 $5,654

Then if someone wants to add creditors, all they have to do is a press an add button and would give the person preformatted/configured fields to enter information and save the creditor. When the user clicks on one of the creditors, it would open up a table containing the creditor information.

This may sound more complicated then need be, but I’m having a hard time trying to figure this out and I’m looking for some help.

I have created a video that I could send to anyone who is willing to help me, to better explain what I am trying to replicate.

Here is a link to the video:

Video Link

Thank you all for your help.

Jason Oswald Jason(at)nationaldc(dot)com

Edited December 12, 2009 by Guest

[comment]

Your link doesn't work for me. Would be it correct to assume that the same creditor can be added to more than one debt (or whatever it is that you're adding them to)?

[NDCinc.]

I have posted a new link, the video is now working. Link

[comment]

You need a join table between the table you are working on (debts? clients?) and the Creditors table - see a demo here:

http://www.fmforums.com/forum/showpost.php?post/246136/

Once you have the proper relational structure in place, you can smarten up the user interface with buttons, pop-up windows, etc. (the demo is purposefully sparse in this aspect).