Very Computer

Hi,

Let's say I have two tables(databases), SupportJobCard and
AccountSoftware.  The AccountSoftware table is defined as:

        AccountNumber           Text
        SoftwareTitle           Text

The SupportJobCard table is defined as:

        AccountNumber           Text
        JobCardID               Number
        SoftwareTitles          Text (repeating 10)
        Details                 Text

The relationship is based on the AccountNumber field.

I want to be able to show in the SoftwareTitles field of the
SupportJobCard table the SoftwareTitle field from all matching records
from the AccountSoftware table.

Is this possible and how would I do it?  I would normally just have a
portal showing the related records, but we want to only show the software
titles at the time the job card was created.  So, if a software title is
added to the account after the job card was created, it will not show on
the support job card.

Any help would be greatly appreciated.

Thanks.

<< I want to be able to show in the SoftwareTitles field of the SupportJobCard
table the SoftwareTitle field from all matching records from the
AccountSoftware table.

Is this possible and how would I do it?  I would normally just have a portal
showing the related records, but we want to only show the software titles at
the time the job card was created.  So, if a software title is added to the
account after the job card was created, it will not show on the support job
card. >>

You need to supply a road map for the repeater, which is essentially a compound
key concatenating the AccountNumber and the repetition numbers for your reps 1
- 10, around a text delimiter, yielding a new repeater "RoadMap" that looks
like:
1359-1
1359-2
1359-3
1359-4...
etc.
You'll need a matching key in your AccountSoftware file, which means
concatenating the AccountNumber and basically a running count of itself around
the same delimiter to yield the matching key.
You can either A) lookup the values into the SoftwareTitles repeater when the
SupportJobCard record is new, or B) use an auto enter calc that polls another
field, perhaps a date in each file that matches, and relies on a local trigger,
C) script the entry based on the same structure of relating the "RoadMap"
repeater to Account Software's matching key. Good luck.

Sincerely,

        Roger E. Grodin
        REDWING FINANCIAL GROUP
        "Where OUR business is the ultimate database for YOUR business"

        ==========================================================