Relationship for existing data
I'm sorry if this was posted already. I have 2 tables - Project & Timesheets. Each table has a job# that will be in both tables, but when this app was built, the job# isn't marked as unique (even thou...
Forum Discussion
Hi Darren,
When you try to mark it as unique do you get a specific error message? One trick I have seen is to create a summary field based on that Job Number field and see if any have duplicates and if they can be fixed so there are no duplicates. Once there are no duplicates you should be able to make that field unique for your uses.
------------------------------
Evan Martinez
------------------------------
When you try to mark it as unique do you get a specific error message? One trick I have seen is to create a summary field based on that Job Number field and see if any have duplicates and if they can be fixed so there are no duplicates. Once there are no duplicates you should be able to make that field unique for your uses.
------------------------------
Evan Martinez
------------------------------