I suggest you ...

Advanced Lookup

It would be great to insert data from more than one field while using the lookup function, maybe to all fields having the same field name.

For example - lets say we have two source table and one target table:
Table A is storing customers
• field customer_id is holding the customers ID
• field customer is holding the customers name
• other fields
Table B is storing goods and prices
• field article_no is holding the article number
• field article is holding the article name
• field price is holding the price
• other fields
Table C should store orders
• field order_no is holding the order number
• field customer_id is holding the customers ID
• field customer is holding the customers name
• field article_no is holding the article number
• field article is holding the article name
• field price is holding the price
• other fields

Is it possible OR might it be possible in the future to automatically fill the fields having identically field names while using lookup?

If i create a new record in Table C, doing a lookup on customer_id in Table A it would automatically fill the data in field customer from Table A as well, and the same way automatically fill the fields article and price from table B when doing a lookup on article_no in that table...

Maybe theres another solution for this construct?

Thanks in andvance

17 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    olove shared this idea  ·   ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base