AnsweredAssumed Answered

Field Lookup ???

Question asked by synergy46 on Apr 9, 2009
Latest reply on Apr 9, 2009 by synergy46

Title

Field Lookup ???

Post

I have a typical 'many-to-many' relationship established:

 

Members Table:

memberID.pk

lastname

firstname

etc.

 

MemberAcct Table:  (Join table)

MemberID.FK

AcctNumber

 

Accounts Table:

AcctNumber

Description

Catgegory

etc...

 

The relationships are set and this works as expected.

 

Question:  "Can I setup a DROPDOWN field in a portal that would show all the account numbers and their descriptions?

 

I know I can do it with Value Lists but can I get the same affect with some kind of lookup?

 

Thanks

 

 

Outcomes