Hi, i'm in urgent need of some help as i've got into a bit of a mess here...
I have the following:
Two tables - [Client Issues] and [Time Recorded]
Both tables have a field called [IssueID], which is unique in the [Client Issues] table.
Also in [Client Issues] I have two additional fields called [Client Name] and [Issue Number].
Basically I want to be able to provide an [Add] (data entry) screen for the [Time Recorded] table, but rather than display the [IssueID] field (which means nothing to the user), I want to display both the [Client Name] and [Issue Number] fields. Then upon selecting [Add] the relevant [IssueID] number would be updated to the [Time Recorded] table.
Kind Regards,
Ryan Aldred
Origin Systems Ltd.
