I have a file that i have been working on that would link a user database with four others; trouble reporting, av projects, machine shop projects and account numbers.
The account numbers are used on the two projects dbases and I would like them to show up as a drop down list. So I created a value list from the accounts dbase, and have it only include related values starting from the Users dbase.
For the most part its working however intermittently i have seen some funky data (e.g. not a full list of accounts).
Is there a best practice for this type of thing? Should i be doing it some other way?
Any help would be greatly appreciated.