Making Tables of Various Sizes Within a Record 1

[jmbter]

I'm trying to make a table in the sense of 5 columns and a varrying number of rows (depending on the record). Is there something that allows me to do this. The table must appear in all records with 5 columns however the number of rows will change with each record. Thanks

 

[jmbter]

Had an additional question. How would I go about displaying the date a file was last modified (if this can't be done, the date it was last accessed). I'm using FMP 7 by the way.

 

[TStriker]

Your question is a bit confusing. Let me see if I understand correctly.

You want to create a spreadsheet like table that has 5 columns and unlimited rows and have it appear in somewhere on the screen of your filemaker application.

An example might be like an invoice where the bulk of the main screen contains header information like customer name, address, phone, terms, PO number, etc. Then within this screen there is a scrolling table of invoice lines that contain stock number, description, unit price, extended price etc.

If this is the kind of thing that you are wishing to do then you should read up on Portals. A portal is a window into data that is contained in another database table but is related to the record that you are viewing.

If you need more help let me know.

-Striker

 

[TStriker]

Your second question is easily done.

FILE -> DEFINE -> DATABASE
Create a field called: Modified_By and make it a TEXT type.
Click the OPTIONS button
On the AUTO ENTER tab check MODIFICATION
Choose ACCOUNT NAME

This will capture the account name of the person who last modified the record. To get the modification date just use the same steps but make the field type TIMESTAMP and choose to auto enter the TIMESTAMP. You could choose to use just a date field but the timestamp will get both the date and time.

-Striker

 

[jmbter]

Sorry for all the posts, but I'm a newb and the more I read, the more I learn. I guess what I'm actually looking to do is to create a list resembling a portal however with no relation to another table; an individual and expandable list for each record.

 

[TStriker]

I think you still want to consider the portal.

There are repeating fields in FileMaker but they have hard limits so this wouldn't be your answer.

If you're comfortable posting your email address I could mock up a quick FP7 file with a portal and send it to you so you could see how portals work.

-Striker

 

[jmbter]

Please do: mantecatrainhouse@hotmail.com

 

[TStriker]

I just sent you a simple example. I zipped it to clear any filtering software.

Hope this helps. Good luck!

-Striker