0

Dynamic choice from Multiple choice field

Hi there!

So I've been browsing on possible solutions but so far nothing that I can understand exactly or addapt it to my case (newbie here!).

I'm trying to code a dC field to retrieve the selections from a multiple choice field and be able to only select one from the many options.

i.e.

Say Customer A has registered two VAT regimes: Margin Scheme and Local VAT in a multiple choice field within the Customer table.

In my 'Entry' table I want that once selected the customer (customer A) I can be able to select only one of the associated VAT regimes.

By only pointing out the dC to the table and field, I get different sets of records with both options separated by comma and only one with just one VAT regime.

I understand that options in multiple choice are diferent records and that they should be addressed as independent records. I've tried the for loop1 coding but I'm definitely missing out something (besides coding experience =D)

Gracias and greetings from Barcelona!

2 replies

null
    • Fred
    • 1 yr ago
    • Reported - view
    Marisol Echaide said:
    Say Customer A has registered two VAT regimes: Margin Scheme and Local VAT in a multiple choice field within the Customer table.

    Your multiple choice field is a regular multiple choice field and NOT a dynamic multiple choice field?

    I'm not sure what you want to do. So a record in Customer has a field called VAT regimes, with two choices (Margin Scheme and Local VAT). Do you plan to make the selection here in the Customer table or do you want to make the selection in the Entry table?

     

    Marisol Echaide said:
    In my 'Entry' table I want that once selected the customer (customer A) I can be able to select only one of the associated VAT regimes.

     Why do you want to have dC in the Entry table but have a multiple choice in Customer? Shouldn't they match field types?

    How do you plan on updating from Entry to Customer? Is the Entry table a dashboard?

      • Marisol_Echaide
      • 1 yr ago
      • Reported - view

      Fred thanks for your questions. They are helping me think over what is the purpose of this data and the concept of a dC field.

      Because of the nature of our business, the assets bought from customers might apply for one or different tipes of VAT (Margin Scheme, local VAT, export -no VAT, tax-free, REBU, etc.). So upon an Entry (basically opening/creating a purchase transaction for one asset -kind of a dashboard) I wanted to have access to the only possible VAT regimes already associated for that specific customer in the Customer table (from a regular multiple choice field). Since the VAT regime data will affect further accounting calculations I wanted to: 1) have this VAT regime as an independent field to be referred to in formulas and 2) prevent the selection of incompatible regimes with that specific customer.

      So I thought that maybe a dC field could do the trick as an independent field. But now I'm not so sure this is the right solution. I stucked with the idea of making it work with the dC. Surely the answer is simpler than it seems and I'm just clouded right now.

Login to reply

Content aside

  • 1 yr agoLast active
  • 2Replies
  • 151Views
  • 2 Following