i did not add the field to the table - it was always part of the table, i just did not pull it over when the wizard asked me what fields i wanted in the report... that is why i am so confused...
i started to strip down my test database the other day... i am just trying to figure out what fields i need to leave so you can make sure the linkage is correct if you try to test anything... with it being a patient database i am trying to remove as much information as possible because of HIPAA and such...
in the meantime i have been going in and sorting manually whenever i get the chance...
thanks for helping - we will figure it out someday lol