Skip to main content
Question

Adding Multipile Lookup Field Values to Parent Record

  • November 2, 2023
  • 0 replies
  • 75 views

Forum|alt.badge.img+9

I am trying to add the ability to add more than one reference lookup field value to a parent record.  I have two tables "Notes" and "Code_Violations".  When I click on the "Create a New Note" button the Note form opens.  On it there is the "Code - Violation" lookup field displaying the code violation options from the "Code_Violaitons" table.  I would like the ability to add multiple code violations to one Note record if possible.  Maybe, if possible, when I select the first one a new Code-Violation lookup field displays ready to add another if desired?



------------------------------
Brian Dunk
------------------------------
This topic has been closed for replies.

MarceloBenavide
Forum|alt.badge.img+8

Good morning. I think that it is not the appropriate design, you must have a table specks and a code_violations table, if you need to associate in a many-to-many relationship you must have a third table in the middle where you can create several notes to several code_violations.



------------------------------
Marcelo Benavides
------------------------------