Let's say I have two tables(databases), SupportJobCard and
AccountSoftware. The AccountSoftware table is defined as:
The SupportJobCard table is defined as:
SoftwareTitles Text (repeating 10)
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.