I have created a table that is associated with a linked table, I am trying to limit entries in one field to entries that are found in the linked table. Because one table is linked I cant enforce referential integrity, is there a way to use the validation rules to do this? The fields that are connected are our customer ID's, there is about 3k in total so a simple list item wont work.
Any thoughts or suggestions are greatly appreciated
Any thoughts or suggestions are greatly appreciated
