Combining multiple fields

May 1, 200223 yr

I dont think this can be done, but thought I would check here to make sure I had tried everything.

I have a database with multiple fields lined up horizontally that looks something like this:

TASK-------START------DUE-------DESCRIPTION------STATUS

TASK2-----START2-----DUE2-----DESCRIPTION2-----STATUS2

TASK3-----START3-----DUE3-----DESCRIPTION3-----STATUS3

The problem with this is each of the items above is a field. And as you can see if I want to add more items for example 4, 5, 6... my page can get pretty long. Plus in some records I may have only 1 task with a start date, due date ect. But in other records I may have 20 of these tasks.

Is there a way to just have the first line of items that allows the addition of how ever many tasks I want, and it expands accordingly.

I am not sure if I am explaining this very well. Hopefully you can get the picture here.

May 1, 200223 yr

Hi,

you say all the items are a field.

If so, then as soon as you start adding Task, Task 2, Task 3, Task 4 etc you must ask yourself, maybe I should do this section in a related database.

Then you only need

TASK-------START------DUE-------DESCRIPTION------STATUS as fields, but you can have multiple records related to any record in your main database.

Then, use a portal to display the information.

This way, you can have just 1 task or 300 tasks related to any record.

You will obviously need some more fields such as RecordID (auto enter serial), and a field to link the task to the main record (say CompanyID).

Create a relationship from your main database to this new database, using the ID field in this database to the related field in the tasks database. If you set allow creation of records to on, you can type in a new record as if it was in that record (but it actually creates it in the new database)

HTH