Auto-complete / references

Options
Ben -5225939
Ben -5225939 Member ✭
in ? Help! I'm a Noob

Hi all,

I am using a ledger DB list to link two DB lists. I wish that ledger DB list to offer an auto complete label that sources the name value of one of these two DB lists. But it seems I can only use the ID as label - am I missing something?

· Share on Twitter

Answers

  • arturosanz
    arturosanz Member ✭✭
    Options

    You can only use the "id" to link two tables, but you can use any field you like as the label from the user perspective. As long as the label you use for the autocomplete is a unique field, you shouldn't have any trouble to match the values. Sometimes using JOINS in "Query All Records" function are useful to handle situations like this.

    · Share on Twitter

Categories