I have two tables and and 1 query. Tables and fields are as follows
Nametbl (table 1)
MemberID (autonumber)
NameFirst
NameLast
Rank
SerialNumber
Memo
TransactionTbl (table 2)
TransactionID (autonumber)
MemberID (number)
TransactionType
AmountReceived
AmountReference
DepositRefernce
ConfirmationStatus
PaymentQuery
TransactionID
MemberID (from table 1) "would like the lookup strategy here"
NameFirst (from table 1)
NameLast (from table 1)
Rank (from table 1)
SerialNumber (from table 1)
TransactionType
AmountReceived
AmountReference
DepositRefernce
ConfirmationStatus
Memo (from table 1)
When I post the payment query in ASPRunner (ver 5.0) I would like to have a lookup on MemberID that would populate [NameFirst], [NameLast], [Rank], [SerialNumber]. I would then finish posting remaining fields. Although far from even being average in ASPrunner I have done lookups as a list or a one table lookup (My difficulties arrive when more than one table is involved. I suspect it may have with your instructions on "joins" and editing the SQL statement. I realize this is more than a ASPrunner question. But any help would sure be appreciated
thank you in advance
-bruce
