Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

What you want to accomplish will take an added column on the form for Table1.

  • Leave the existing 'PositionFK' column as a listbox but remove any restrictions (ie: all available from Table2)
  • Set the properties on that column for Enabled to No & change title to "Existing Position"
  • Insert a NEW column on the grid with the same original criteria as "PositionFK" (Enabled = Yes; limit restrictions)
  • Give this column a title such as "Select Position"

This should result in a display as:

image description

This establishes a connection to Table2 using the Existing Position column, but only allows specific choices from the Select Position column to update the actual field in Table1.

What you want to accomplish will take an added column on the form for Table1.

  • Leave the existing 'PositionFK' column as a listbox but remove any restrictions (ie: all available from Table2)
  • Set the properties on that column for Enabled to No & change title to "Existing Position"
  • Insert a NEW column on the grid with the same original criteria as "PositionFK" (Enabled = Yes; limit restrictions)
  • Give this column a title such as "Select Position"

This should result in a display as:

image description

This establishes a connection to Table2 using the Existing Position column, but only allows specific choices from the Select Position column to update the actual field in Table1.

If this answers your question please click on the ✔ (upper left area of answer).